Which operation changes the structure of an existing table?

Study for the SQL Basics Test. Improve your knowledge with multiple choice questions and detailed explanations. Prepare effectively to master SQL concepts!

Multiple Choice

Which operation changes the structure of an existing table?

Explanation:
Changing the structure of an existing table is done with ALTER TABLE. This command modifies the table’s schema—adding or dropping columns, changing a column’s data type, adjusting constraints, or even renaming the table. It’s about the table’s definition, not the data itself. Update changes values inside existing rows, Delete From removes rows, and Create Table builds a new table with its own schema, so they don’t alter the structure of an existing table.

Changing the structure of an existing table is done with ALTER TABLE. This command modifies the table’s schema—adding or dropping columns, changing a column’s data type, adjusting constraints, or even renaming the table. It’s about the table’s definition, not the data itself.

Update changes values inside existing rows, Delete From removes rows, and Create Table builds a new table with its own schema, so they don’t alter the structure of an existing table.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy