/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 vote288 views2 answers
How to combine diff colmun value using group by postgres
SQL
3 votes299 views3 answers
Restart mysql mac
SQL
0 vote286 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote283 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote300 views1 answer
Sql sum if
SQL
0 vote271 views1 answer
How to check if there is no database schema
SQL
3 votes301 views1 answer
Oracle function return
SQL
0 vote246 views1 answer
CREATE MULTIPLE FK
SQL
0 vote316 views1 answer
How to make sure two tables have same exact data in sql
SQL
3 votes306 views3 answers
Mysql declare variable
SQL

Share