Select the correct answerWhich SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsALTER TABLEDELETE TABLEMODIFY TABLECHANGE TABLE
Question
Select the correct answerWhich SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsALTER TABLEDELETE TABLEMODIFY TABLECHANGE TABLE
Solution 1
The correct SQL statement used to make changes to the structure of an existing table without deleting it is "ALTER TABLE".
Solution 2
The correct answer is ALTER TABLE. This SQL statement is used to add, delete/drop or modify columns in an existing table. It is also used to add and drop various constraints on an existing table.
Similar Questions
Which SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsDELETE TABLEALTER TABLEMODIFY TABLECHANGE TABLE
Select the correct answerIn SQL, which command(s) is(are) used to change a table's storage characteristics?OptionsCHANGE TABLEMODIFY TABLEALTER TABLEAll of these
Select the correct answer What is the SQL keyword used to remove a table from the database?OptionsDELETE TABLEREMOVE TABLEDROP TABLEERASE TABLE
Select the correct answerIn SQL, which statement is used to remove a table definition and its data from the database?OptionsDROP TABLEDELETE TABLEREMOVE TABLEERASE TABLEFinish ClearPrev Next
In SQL, which command is used to change data in a table?OptionsALTERMODIFYCHANGEUPDATE
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.