Question

What SQL command can be used to delete columns from a table?
A.MODIFY TABLE TableName DROP ColumnName
B.MODIFY TABLE TableName DROP COLUMN ColumnName
C.ALTER TABLE TableName DROP ColumnName
D.ALTER TABLE TableName DROP COLUMN ColumnName

Answer 1

______✨ HEY MATE ✨______

➡️Option (c) is the right answer ✔️


✌✌Hope it's help u ✌✌

Answer 2

The SQL command which can be used to delete columns from a table is (C) ALTER TABLE TableName DROP ColumnName

• The SQL command is used to delete columns from a table.
• ALTER TABLE statement is used to add and drop various constraints on an existing table.
• ALTER TABLE statement can also be used to add a column, modify a column, rename the column or rename the table.
• DROP COLUMN is used to specify to delete the column in an existing table.

#SPJ3