/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

7 votes261 views2 answers
Mysql default value
SQL
3 votes242 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote265 views1 answer
Mysql range of dates overlap
SQL
12 votes257 views4 answers
Mysql get date difference in hours
SQL
0 vote265 views1 answer
Restore backup mysql .gz
SQL
0 vote259 views1 answer
Sql server set complex constraints
SQL
3 votes270 views1 answer
Postgresql today - 1 year
SQL
0 vote209 views1 answer
Sql select rows with simlar names
SQL
0 vote251 views1 answer
Varchar format not case sensitive sql
SQL
0 vote292 views1 answer
Get initial in sql
SQL

Share