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

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

CREATE. The CREATE Keyword is used to create a database, table, views, and index.

Which command is used to create a table in SQL?

Syntax. CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );

Which SQL clause is used to query on table?

SELECT Clause in SQL. Select clause is used to query the database and display the output.

Which keyword is used in SQL?

KeywordDescriptionGROUP BYGroups the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG)HAVINGUsed instead of WHERE with aggregate functionsINAllows you to specify multiple values in a WHERE clauseINDEXCreates or deletes an index in a table