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 vote85 views1 answer
Create a sql server database programmatically
SQL
7 votes96 views2 answers
How to create index mysql
SQL
4 votes76 views2 answers
How to insert ip address in mysql using php
SQL
0 vote73 views1 answer
Mysql to get column name in database
SQL
0 vote70 views1 answer
Login failed for login due to trigger execution
SQL
0 vote35 views1 answer
Expose db in virtualbox
SQL
6 votes76 views2 answers
Mysql get yesterday
SQL
10 votes72 views2 answers
Reset mysql root password mac
SQL
1 vote71 views3 answers
Psql fatal database does not exist
SQL
0 vote71 views3 answers
Postgresql allow remote connections
SQL