/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 vote165 views1 answer
Oracle current timestamp
SQL
4 votes179 views5 answers
Primary key
SQL
1 vote188 views1 answer
Sql server kill all connections
SQL
8 votes180 views1 answer
Script to add datafile to tablespace
SQL
0 vote125 views1 answer
Mysql convert column to uppercase
SQL
0 vote192 views1 answer
Frename oracle
SQL
0 vote181 views1 answer
Drop-toys-table
SQL
1 vote212 views1 answer
Postgresql blocked on mac
SQL
3 votes207 views1 answer
RENAME table pl sql
SQL
4 votes167 views1 answer
Mysql copy table with new name
SQL

Share