Which SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsALTER TABLEDELETE TABLEMODIFY TABLECHANGE TABLE
Question
Which SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsALTER TABLEDELETE TABLEMODIFY TABLECHANGE TABLE
Solution
The SQL statement used to make changes to the structure of an existing table without deleting it is ALTER TABLE.
Similar Questions
Which of the SQL command is used to change the structure of a table after it has been created?UPDATEALTERDROPTRUNCATENone of the above
In SQL, which command is used to change data in a table?OptionsALTERMODIFYCHANGEUPDATE
In SQL, which statement is used to remove a table definition and its data from the database?OptionsERASE TABLEDROP TABLEDELETE TABLEREMOVE TABLE
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETETRUNCATEDROPREMOVE
Which SQL statement is used to change the name of a table?OptionsRENAMEALTER TABLEMODIFYCHANGE TABLE
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.