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;

Similar codes

1 vote357 views1 answer
Too many connections mysql
SQL
0 vote334 views1 answer
Postgresql isnull with max
SQL
3 votes418 views3 answers
Update con select postgresql
SQL
0 vote351 views1 answer
Null column as zero in mysql
SQL
2 votes354 views1 answer
Postgresql left join distinct on
SQL
0 vote352 views1 answer
Oracle db get table sizes
SQL
0 vote349 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
2 votes354 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
5 votes348 views3 answers
How to remove unique key constraint in mysql
SQL
29 votes348 views6 answers
Delete all rows from table mysql
SQL