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

2 votes180 views1 answer
How to select first row of database sql
SQL
10 votes182 views2 answers
Mysql alter add foreign key
SQL
0 vote185 views1 answer
Sql server remove 0 from left
SQL
1 vote152 views1 answer
Psql kill pid
SQL
0 vote205 views1 answer
Sql remove non numeric characters
SQL
0 vote179 views1 answer
Myswql show full processlist
SQL
0 vote175 views1 answer
In mysql workbench contnent not feching
SQL
1 vote169 views1 answer
Avg mysql
SQL
12 votes205 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote171 views1 answer
Metada in sql
SQL