On delete set default sql server

Sql server drop constraint default value

ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint]

Source: stackoverflow.com

Sql drop default

Removes a default value for a column.
Example (MySQL): Removes the default value from the ‘name’ column in
the ‘products’ table.
ALTER TABLE products
ALTER COLUMN name DROP DEFAULT;

-1

Source: grepper.com

Similar codes

-1 vote190 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote244 views1 answer
Mysql return text after a final full stop
SQL
1 vote228 views1 answer
Increase existing date in sql oracle
SQL
0 vote276 views1 answer
Sql get table last modified time
SQL
6 votes261 views2 answers
How to get yesterday date in mysql
SQL
1 vote194 views1 answer
Sql upsert
SQL
0 vote255 views1 answer
Capabilities of sql select statements
SQL
8 votes219 views1 answer
Script to add datafile to tablespace
SQL
0 vote310 views1 answer
Store case result sql
SQL
1 vote221 views2 answers
Postgresql check privileges on schema
SQL