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

0 vote132 views1 answer
Mysql export and import
SQL
0 vote134 views1 answer
Sql join on a subquery
SQL
0 vote138 views1 answer
Sql drop procedure if exists
SQL
0 vote127 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote160 views1 answer
Mysql dump with table query
SQL
4 votes155 views2 answers
Tables in sql
SQL
7 votes143 views1 answer
Query postgres delete duplicates
SQL
1 vote146 views1 answer
Psql import backup file for windows
SQL
1 vote140 views1 answer
Timestamp in sqlite
SQL
3 votes169 views2 answers
Find string in stored procedure sql server
SQL