/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 vote207 views1 answer
Sql show founctions
SQL
3 votes349 views6 answers
Sql unique select
SQL
1 vote186 views7 answers
Filter
SQL
4 votes183 views1 answer
To date oracle with time
SQL
11 votes210 views3 answers
Sql line numbers
SQL
3 votes183 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote184 views4 answers
Database stuck at restoring state
SQL
5 votes222 views1 answer
Get table columns from sql
SQL
-1 vote243 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote255 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL

Share