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

0 vote379 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote348 views1 answer
Sql try catch
SQL
0 vote409 views1 answer
How to find date from date table in sql
SQL
0 vote342 views2 answers
Postgresql get long running queries
SQL
0 vote326 views0 answer
SQL
0 vote374 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
3 votes308 views1 answer
How to get list of synonyms in oracle
SQL
0 vote388 views1 answer
Sql select column name like from multiple tables
SQL
0 vote344 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote345 views1 answer
Mysql grant access to one database
SQL