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 vote324 views1 answer
Oracle grant select on schema
SQL
0 vote336 views1 answer
Insert ip address in mysql
SQL
3 votes315 views4 answers
Show databases in sql server
SQL
1 vote367 views1 answer
Oracle select first row order by
SQL
1 vote320 views1 answer
Find difference in dates sql
SQL
0 vote325 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote330 views1 answer
Intellij idea add mysql connector
SQL
0 vote329 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
2 votes315 views1 answer
Query to find table size in oracle 12c
SQL
0 vote308 views1 answer
Check psql validity function
SQL