Which of the following keywords cannot be used to modify an existing table?
A) ALTER TABLE...ADD
B) ALTER TABLE...DROP COLUMN
C) ALTER TABLE...MODIFY
D) ALTER TABLE...AS

Question

Which of the following keywords cannot be used to modify an existing table?​
A) ​ALTER TABLE...ADD
B) ​ALTER TABLE...DROP COLUMN
C) ​ALTER TABLE...MODIFY
D) ​ALTER TABLE...AS

Quizplus · Accepted Answer

ALTER TABLE...AS is not a valid SQL statement. The correct syntax is ALTER TABLE followed by the modification keyword such as ADD, DROP COLUMN, or MODIFY.

Which of the Following Keywords Cannot Be Used to Modify