Which SQL command is used to create a new table?

The command used to create a new table in SQL is "CREATE TABLE." This command establishes a new table within a database, allowing the user to define the table's structure, including its name, the columns it contains, data types for each column, and any constraints such as primary keys or foreign keys.

For example, when you use the CREATE TABLE command, the syntax typically follows this structure:

CREATE TABLE table_name (

column1 datatype,

column2 datatype,

...

);

This command is fundamental for database creation and ensures that the database is organized in a way that supports data storage and retrieval.

In contrast, the other commands listed have different purposes:

• ALTER TABLE modifies an existing table's structure.

• INSERT INTO adds rows of data to an existing table.

• UPDATE changes existing data within the table.

Thus, "CREATE TABLE" is the specific command designated for structuring new tables within an SQL database.