Which statement represents the correct syntax to add columns to a table?

All Questions › Category: Database › Which statement represents the correct syntax to add columns to a table?
0 Vote Up Vote Down
Anonymous asked 3 years ago

Options:

  1. ALTER TABLE <name of table> ALTER COLUMN (<name of column>) GO
  2. NEW TABLE <name of table> ADD COLUMN (<name of column>) GO
  3. ALTER TABLE <name of table> ADD (<list of columns>) GO
  4. ALTER TABLE <name of table> NEW (<list of columns>) GO
  5. ALTER TABLE <name of table> CREATE COLUMN (<list of columns>) GO

  6. ALTER TABLE <name of table> CREATE (<list of columns>) GO

1 Answers
0 Vote Up Vote Down
Anonymous answered 3 years ago
  1. ALTER TABLE <name of table> ADD (<list of columns>) GO