/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 vote150 views1 answer
How to insert same table data using mysql query
SQL
0 vote173 views1 answer
Display all node label neo4j
SQL
0 vote138 views1 answer
Soql queries for not contact related account records in salesforce
SQL
1 vote126 views1 answer
Mysql get character set
SQL
0 vote129 views1 answer
Pl sql constraint user function
SQL
1 vote134 views1 answer
Oracle difference between two dates in years
SQL
1 vote143 views2 answers
Mysql update table from another table
SQL
0 vote135 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote136 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote133 views1 answer
Oracle archivelog usage
SQL

Share