Disable ads (and more) with a premium pass for a one time $4.99 payment
The command used to add a new table to a database is "CREATE TABLE." This command is specifically designed for creating a new table with a defined structure, including specifying the table name, the columns it will contain, and the data types for each column.
Using "CREATE TABLE," a database administrator or developer can set up the foundational organization of data, thus enabling the storage and retrieval of information in a structured way. The new table will then be ready to accept data entries through subsequent commands like "INSERT INTO."
In contrast, other options pertain to different operations within a database. For example, "ALTER TABLE" modifies an existing table's structure, "INSERT INTO" is used for adding new records to an existing table, and "UPDATE TABLE" is not a valid command as updates occur within the context of existing records, typically using the "UPDATE" command. Hence, "CREATE TABLE" is the accurate choice for adding a new table to a database.