Select the correct answerWhich of the following commands is used to delete all rows and free up space from a table?OptionsDELETEDROPTRUNCATEALTER
Question
Select the correct answerWhich of the following commands is used to delete all rows and free up space from a table?OptionsDELETEDROPTRUNCATEALTER
Solution
To delete all rows and free up space from a table, the correct command to use 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?OptionsDELETE ALLREMOVEDROPTRUNCATE
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
___________removes all rows from a table without logging the individual row deletions.DELETEREMOVEDROPTRUNCATE
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
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.