/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 vote373 views1 answer
Oracle job session
SQL
11 votes366 views2 answers
You are using safe update mode
SQL
0 vote361 views1 answer
Changing name of column and datatype in sql
SQL
0 vote383 views1 answer
Mysql change default collation
SQL
3 votes348 views2 answers
Truncate all tables
SQL
17 votes363 views6 answers
Current date in sql
SQL
0 vote353 views1 answer
Oracle sql date winter time
SQL
1 vote331 views4 answers
Fatal database postgres does not exist
SQL
1 vote351 views1 answer
Blob datatype in mysql
SQL
0 vote347 views1 answer
Mysql workbench view
SQL

Share