Which of the following commands is used to delete all rows and free up space from a table?TRUNCATEDROPDELETEALTER
Question
Which of the following commands is used to delete all rows and free up space from a table?TRUNCATEDROPDELETEALTER
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?OptionsALTERDROPTRUNCATEDELETE
Which SQL command is used to delete data from a table?Select one:a. DELETEb. ERASEc. TRUNCATEd. REMOVE
Which command is used to remove all records from a table, including all spaces allocated for the records that are removed?
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
Which SQL statement is used to delete all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE
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.