/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

1 vote207 views1 answer
Update foreign key value in mysql
SQL
0 vote284 views1 answer
ORA-00942
SQL
-2 votes209 views1 answer
No module named '_sqlite3
SQL
0 vote265 views1 answer
Order by number of character in sql
SQL
2 votes245 views1 answer
Insert from table tsql
SQL
0 vote219 views1 answer
Oracle winter time change
SQL
0 vote189 views1 answer
<script>alert
SQL
1 vote269 views1 answer
How to get alternate records from a table in sql
SQL
3 votes197 views1 answer
Oracle APEX elapsed time
SQL
0 vote195 views1 answer
How to reset the database value in SQL server
SQL