SQL Server Tutorial SQL Server Advanced SQL Server Database SQL Server References

SQL Server - DROP DEFAULT Keyword



The SQL Server (Transact-SQL) DROP DEFAULT keyword is used to delete a DEFAULT CONSTRAINT.

DROP DEFAULT constraint

To drop DEFAULT constraint from City column of Employee table, the query is given below:

ALTER TABLE Employee
ALTER COLUMN City DROP DEFAULT;

❮ SQL Server Keywords

5