/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

1 vote274 views1 answer
Into sql
SQL
0 vote377 views1 answer
Tsql cte in a transaction
SQL
0 vote321 views1 answer
This week mysql
SQL
7 votes282 views1 answer
Alter table add key sql
SQL
0 vote383 views1 answer
Mysql dump for selected row
SQL
0 vote323 views1 answer
How to find username and password in oracle 18c
SQL
0 vote343 views1 answer
Soql update query
SQL
2 votes327 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
6 votes315 views2 answers
Mysql first day of month
SQL
0 vote346 views1 answer
Hou to run job from cmd .exe sql server jop
SQL

Share