Which keyword is used to define a new table in SQL?

Which keyword is used to create a new table?

Syntax. CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) ); CREATE TABLE is the keyword telling the database system what you want to do.

Which SQL keyword is used for defining new tables or databases?

Terms in this set (94) The SQL CREATE TABLE statement is used to name a new table and describe the table's columns. The SQL keyword CONSTRAINT is used to define one of several types of constraints.

How do you CREATE a new table in SQL?

SQL CREATE TABLE Statement1CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ... 2Example. CREATE TABLE Persons ( PersonID int, ... 3CREATE TABLE new_table_name AS. SELECT column1, column2,... FROM existing_table_name. ... 4Example. CREATE TABLE TestTable AS. SELECT customername, contactname.

Which SQL keyword must be used in a Make table query?

The SQL keyword FROM is used to specify the table to be used. SQL can only query a single table. SQL statements end with a colon. The columns to be obtained by an SQL command are listed after the FROM keyword.