Which of the following commands is used to delete all rows and free up space from a table?OptionsALTERDROPTRUNCATEDELETE
Question
Which of the following commands is used to delete all rows and free up space from a table?OptionsALTERDROPTRUNCATEDELETE
Solution
The command used to delete all rows and free up space from a table is TRUNCATE.
Similar Questions
Which of the following commands is used to delete all rows and free up space from a table?TRUNCATEDROPDELETEALTER
Which SQL statement is used to delete all records from a table?OptionsDROPTRUNCATEDELETE ALLREMOVE
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
___________removes all rows from a table without logging the individual row deletions.DELETEREMOVEDROPTRUNCATE
Choose the correct options. __________ command is used to delete the records and _________ command is used to delete the db objects?Select one:Drop ,TruncateDelete , TruncateTruncate , DropTruncate , DeleteClear my choice
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.