Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

How to Remove a Default Value to a Column in SQL Server in SQL Server

To remove a default value to a column in SQL Server, use the ALTER TABLE .. DROP CONSTRAINT command:

alter table products
drop constraint df_category;

Ready for a modern SQL editor?