Which of the following is the correct syntax for creating a table in SQL ?
2025
Which of the following is the correct syntax for creating a table in SQL ?
- A.
CREATE TABLE table_name (column1 datatype, column2 datatype,...);
- B.
ADD TABLE table_name (column1 datatype, column2 datatype, ...);
- C.
NEW TABLE table_name (column1 datatype, column2 datatype,...);
- D.
TABLE CREATE table_name (column1 datatype, column2 datatype,...)
Attempted by 115 students.
Show answer & explanation
Correct answer: A
The correct syntax for creating a table in SQL is CREATE TABLE followed by the table name and column definitions. This statement defines the structure including data types for each column within parentheses.