Which of the following statements removes the Comments field from the Projects table?
A)ALTER TABLE Projects DELETE FIELD Comments;
B)DROP Comments FROM Projects;
C)ALTER TABLE Projects DROP COLUMN Comments;
D)DELETE COLUMN Comments FROM Projects;

Question

Quizplus · Accepted Answer

The correct SQL syntax to remove a column from a table is "ALTER TABLE [TableName] DROP COLUMN [ColumnName];" making option C the correct choice.

Which of the Following Statements Removes the Comments Field from the Projects