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

5 votes304 views2 answers
Create function postgresql
SQL
1 vote310 views1 answer
How to use db.execute
SQL
1 vote290 views1 answer
Sql sort column by date
SQL
10 votes318 views4 answers
Else if mysql
SQL
0 vote328 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
1 vote314 views2 answers
Oracle create synonym
SQL
1 vote303 views1 answer
Postgres killing connections on db
SQL
5 votes336 views1 answer
Mysql count lines
SQL
0 vote324 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
2 votes318 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL