Q53
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
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
To delete columns from a table in SQL, you can use the ALTER TABLE TableName DROP COLUMN ColumnName command. Option D is the correct choice for removing columns from a table. Options A, B, and C do not represent the standard SQL syntax for deleting columns.