/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 vote179 views1 answer
Enable Rabbitmq management plugin
SQL
1 vote178 views2 answers
Install mysqldump ubuntu
SQL
0 vote182 views1 answer
New rails app with mysql
SQL
11 votes206 views2 answers
Set default column value sql
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL
50 votes292 views6 answers
Sql count duplicate rows
SQL
3 votes163 views1 answer
Sql timestamp to date
SQL
0 vote260 views1 answer
Mysql loop through databases and execute query
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
1 vote194 views1 answer
Sql find column name like
SQL

Share