In SQL, which command is used to remove a table's data but keep the structure?OptionsREMOVETRUNCATEDELETEDROP
Question
In SQL, which command is used to remove a table's data but keep the structure?OptionsREMOVETRUNCATEDELETEDROP
Solution 1
The command used in SQL to remove a table's data but keep the structure is TRUNCATE.
Solution 2
The command used to remove a table's data but keep the structure in SQL is TRUNCATE.
Similar Questions
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
Which command is used for removing a table and all its data from the database?
Which SQL statement is used to delete all records from a table?OptionsDROPTRUNCATEDELETE ALLREMOVE
In SQL, which of the following is used to delete both the table data and structure?
In SQL, which statement is used to remove a table definition and its data from the database?OptionsDELETE TABLEREMOVE TABLEERASE TABLEDROP 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.