Remove Not Null Constraint on a column using Alter Table statement
October 5th, 2010
1 comment
Many times , it may be necessary to remove Not Null constraint used for a column in a table. It is usually necessary to overcome unexpected integrity constraints ( rarely occurs, if designed well) against a table. We can remove the Not Null constaint by using ALTER TABLE …. ALTER COLUMN … option.
Categories: Alter, alter, alter, SQL Queries, SQL Queries, SQL Server, SQL Server, T-SQL, T-SQL, T-SQL, Tips & Tricks Alter, alter column, alter table, not null, null, SQL Server