/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 vote260 views1 answer
Unique index in mysql
SQL
0 vote258 views1 answer
Select from another database
SQL
3 votes255 views1 answer
Oracle user quota on tablespace
SQL
0 vote253 views1 answer
Default column value in sql same as other column
SQL
0 vote218 views1 answer
Connection error in mysql workbench
SQL
0 vote258 views1 answer
Sql find table by name
SQL
17 votes292 views4 answers
Show tables sql server
SQL
3 votes262 views1 answer
Select without null values sql
SQL
0 vote261 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
41 votes344 views6 answers
Alter table add column in SQL Server
SQL

Share