/SQL/Mysql drop column

Mysql drop column

Alter table delete column

ALTER TABLE "table_name" DROP "column_name";

23

Add column in mysq

ALTER TABLE Table_name
ADD Email varchar(255);

15

Psql drop column

ALTER TABLE table_name 
DROP COLUMN column_name;

12

Mysql drop column

ALTER TABLE `claims_user_settings` DROP COLUMN `super_user`;

8

Source: techonthenet.com

Similar codes

0 vote137 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote162 views1 answer
Time data type in mysql
SQL
0 vote135 views1 answer
Mysql timediff
SQL
0 vote132 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote133 views1 answer
Heavy table in mysql
SQL
3 votes148 views2 answers
How to delete git repo locally
SQL
0 vote171 views1 answer
Inner join distinct
SQL
0 vote130 views1 answer
Postgresql heritage
SQL
22 votes155 views4 answers
Date format mysql
SQL
0 vote149 views1 answer
Compare if is null sql
SQL

Share