/SQL/Sql make column nullable

Sql make column nullable

Change A filed to not null

ALTER TABLE
  clients
ALTER COLUMN
  phone
    NVARCHAR(20) NOT NULL;

5

Source: chartio.com

Sql server alter table column nullable

ALTER TABLE Customer
	ALTER COLUMN CustDesc NVARCHAR(MAX) NULL;

0

Source: stackoverflow.com

Sql make column nullable

ALTER TABLE [ExampleTable] ALTER COLUMN [ExampleColumn] INT NULL

0

Similar codes

0 vote138 views1 answer
Check if string is a number sql
SQL
0 vote135 views1 answer
How to use group_concat in sql server
SQL
4 votes149 views1 answer
Adding data to table in sql python
SQL
0 vote146 views1 answer
Mysql query to select the highest value
SQL
0 vote157 views1 answer
Sqlalchemy query join many to many
SQL
1 vote137 views1 answer
Rename table column name in mysql
SQL
0 vote133 views6 answers
Unique key in sql
SQL
-2 votes130 views1 answer
How to open database
SQL
-1 vote96 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
11 votes140 views6 answers
Distinct sql
SQL

Share