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 vote141 views1 answer
Find logged in users mysql
SQL
0 vote156 views2 answers
Sql regex vowel
SQL
0 vote155 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote148 views1 answer
Mysql in clausule string array
SQL
1 vote157 views1 answer
SQL date part only of datetime
SQL
1 vote160 views1 answer
Sql server: query to find out all the places where the table is used
SQL
-1 vote166 views1 answer
Mysql extract days
SQL
0 vote161 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
3 votes152 views1 answer
Sql is not like
SQL
8 votes151 views1 answer
Oracle add auto_increment column to existing table
SQL