CS Electrical And Electronics
@cselectricalandelectronics

Which statement represents the correct syntax to create new tables in SQL Server 2016?

All QuestionsCategory: DatabaseWhich statement represents the correct syntax to create new tables in SQL Server 2016?
Anonymous asked 3 years ago

Options:

  1. NEW TABLE <name of table> ADD COLUMN <name of column> GO
  2. CREATE TABLE <name of table> ALTER TABLE (<list of columns>) GO
  3. CREATE TABLE <name of table> (<list of columns>) GO
  4. NEW TABLE <name of table> CREATE COLUMNS (<list of columns>) GO
  5. CREATE TABLE <name of table> ADD COLUMN <name of column> GO
  6. CREATE TABLE <name of table> CREATE COLUMNS (<list of columns>) GO
1 Answers
Anonymous answered 3 years ago
  1. CREATE TABLE <name of table> (<list of columns>) GO