/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

5 votes287 views1 answer
Oracle get foreign keys on table
SQL
0 vote315 views2 answers
Mysql show foreign keys
SQL
0 vote291 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote295 views1 answer
Sqlite explain plan
SQL
0 vote293 views1 answer
Like date sql server not working
SQL
0 vote280 views1 answer
Get foreign table names mysql
SQL
0 vote291 views1 answer
Oracle temporary table
SQL
0 vote282 views1 answer
Groupby error in mysql
SQL
1 vote287 views1 answer
Duplicating a MySQL table with all the data Command
SQL
8 votes277 views1 answer
Oracle add month
SQL

Share