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 vote279 views1 answer
Md5 encryption for existing records
SQL
6 votes265 views2 answers
WHERE value IS sql
SQL
4 votes300 views1 answer
Sql delete multiple conditions
SQL
0 vote281 views1 answer
Creating a simple notify in postgresql
SQL
0 vote273 views1 answer
Cannot start database server xampp mac os
SQL
0 vote250 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
1 vote312 views1 answer
Oracle plan hash value
SQL
1 vote314 views1 answer
Opensuse restart MySQL
SQL
0 vote267 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
17 votes336 views4 answers
Show all tables in oracle
SQL