How to remove NOT NULL Constraints. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to remove NOT NULL Constraints.

Hi How to remove NOT NULL Constraints defined for a table
without using the Enterprise Manager. Thanks raj
Use this: alter table <Table Name>
alter column <column Name> <datatype> null
Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
NULL can be specified in ALTER COLUMN to make a NOT NULL column allow null values, except for columns in PRIMARY KEY constraints. NOT NULL can be specified in ALTER COLUMN only if the column contains no null values. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>