Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql drop column

ALTER TABLE `claims_user_settings` DROP COLUMN `super_user`;
Comment

how to remove a column from a table in MySQL

ALTER TABLE table_name DROP column_name;
#example
ALTER TABLE student DROP first_name;
Comment

delete column from table mysql query

ALTER TABLE tableName CHANGE oldcolname newcolname datatype(length);
Comment

delete column from table mysql query

ALTER TABLE tableName CHANGE oldcolname newcolname datatype(length);
Comment

PREVIOUS NEXT
Code Example
Sql :: grant read only privileges postgres user 
Sql :: grant all privileges mysql 
Sql :: create unique index postgres 
Sql :: sql create index 
Sql :: oracle add auto_increment column to existing table 
Sql :: mysql how to change default charset 
Sql :: sql where keyword contains 
Sql :: query saurce oracle 
Sql :: Suse Linux restart MySQL 
Sql :: pl sql disable trigger 
Sql :: how to delete a record from sqlite in android 
Sql :: SQL loop with cursor 
Sql :: postgres type cast to string 
Sql :: db.Database.SqlQuery 
Sql :: sql update table remove spaces 
Sql :: install postgresql centos 5 
Sql :: sql show all users 
Sql :: psql select unique 
Sql :: how to use group_concat in sql server 
Sql :: create user sql server 
Sql :: date to string mariadb 
Sql :: postgres delete all tables 
Sql :: drop df constraint sql server 
Sql :: sql mm/dd/yyyy format 
Sql :: run mysql file in terminal 
Sql :: how to export only procedures mysql 
Sql :: sql compare strings 
Sql :: current date in postgresql minus 1 day 
Sql :: greater than in mongodb query 
Sql :: delete all value query 
ADD CONTENT
Topic
Content
Source link
Name
4+8 =