0

this is the normal code for DELETE one data in one clmn DELETE FROM t.name WHERE clmn="data"; but what is the code for DELETE clmn? come on guys answer me!

COLUMN DELETE!

1st Oct 2016, 5:15 AM
Aslim Mohamed
Aslim Mohamed - avatar
3 odpowiedzi
+ 3
ALTER TABLE table DROP COLUMN clmn This deletes the collum “clmn“ from the table “table“
1st Oct 2016, 8:43 AM
Jonas Geiler
Jonas Geiler - avatar
0
ALTER TABLE t.name DROP COLUMN clmn;
1st Oct 2016, 7:47 PM
guizani mahmoud
guizani mahmoud - avatar
0
It's done with Alter Table command. Syntax is : Alter Table <Table Name> Drop < Column Name >
7th Oct 2016, 4:32 AM
Abhinandan Jain
Abhinandan Jain - avatar