/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

23 votes148 views6 answers
Create table sql server
SQL
1 vote139 views1 answer
Right outer vs left outer join
SQL
0 vote126 views1 answer
Get only first row mysql
SQL
11 votes137 views5 answers
How to install sqlite3 python
SQL
1 vote163 views1 answer
Sql query row number group by
SQL
0 vote148 views1 answer
Oracle INTERVAL DAY to second to number
SQL
2 votes137 views1 answer
Get first n letter of department name in sql
SQL
0 vote153 views1 answer
Redshift running queries
SQL
3 votes143 views1 answer
Postgresql db owner change
SQL
0 vote157 views1 answer
Get relation data in mysql using query to excel
SQL

Share