/SQL/Remove default constraint sql server

Remove default constraint sql server

ALTER TABLE <schema_name, sysname, dbo>.<table_name, sysname, table_name>
   DROP CONSTRAINT <default_constraint_name, sysname, default_constraint_name>
GO

Source: stackoverflow.com

Similar codes

0 vote186 views1 answer
How to count with except in psql
SQL
0 vote204 views1 answer
Search db for table name
SQL
0 vote264 views2 answers
Return the number of records in a single table mysql
SQL
19 votes188 views2 answers
Mysql add column after another
SQL
1 vote236 views2 answers
Difference between in and between in sql
SQL
0 vote195 views2 answers
2nd max salary query in sql
SQL
0 vote209 views1 answer
View psql output in horizontal scrolling
SQL
1 vote188 views1 answer
Setval pgsql
SQL
0 vote199 views1 answer
Sql server for loop
SQL
0 vote202 views1 answer
Search starting with mysql
SQL