/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 vote273 views2 answers
How covert into int in maria db
SQL
0 vote280 views1 answer
Bidirectional outer join sql
SQL
-1 vote279 views1 answer
Phinehas Psalm 106
SQL
0 vote261 views1 answer
Show create table in postgresql
SQL
0 vote257 views1 answer
Oracle synonym procedure
SQL
0 vote260 views1 answer
Mod in sql
SQL
0 vote258 views1 answer
How to create an SQL save method in ruby
SQL
17 votes282 views4 answers
Postgres list users
SQL
-1 vote222 views1 answer
How to create script to connect to oracle database and run query
SQL
1 vote266 views1 answer
List all triggers in SQL Server
SQL