Knowee
Questions
Features
Study Tools

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

🧐 Not the exact question you are looking for?Go ask a question

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

1/3

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.