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 vote343 views1 answer
Sql count more than 1
SQL
51 votes451 views6 answers
Change column name sql
SQL
2 votes372 views3 answers
Sql server reseed identity column
SQL
0 vote360 views1 answer
SQL column name Oracle
SQL
13 votes345 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
9 votes365 views3 answers
Date format in sql
SQL
0 vote353 views1 answer
Sql select random procentage from rows
SQL
0 vote346 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote361 views1 answer
Store select query result in variable sql server
SQL
-2 votes344 views1 answer
Use of where in left join in mysql
SQL