Question

Which command is used to add a column into database table?

• A. ADD COLUMN
• B. ALTER TABLE
• C. INSERT COLUMN
• D. All the above

Answer 1

Answer:

B. ALTER TABLE

• The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
• The ALTER TABLE statement is also used to add and drop various constraints on an existing table.