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

4 votes215 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote231 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote222 views1 answer
Sql cnvert bit to nvarchar
SQL
5 votes208 views3 answers
Mysql check if null or empty string
SQL
3 votes228 views3 answers
1396(hy00) mysql error
SQL
0 vote240 views1 answer
Implode in sql query
SQL
0 vote214 views3 answers
Magento 2 order delete from db
SQL
-1 vote191 views3 answers
Mysql get age from date
SQL
0 vote226 views1 answer
Sql field equals multiple values
SQL
1 vote195 views1 answer
What is int in mysql
SQL