Question
Which command is used to remove all records from a table
without deleting the table structure?Solution
TRUNCATE quickly removes all rows from a table, but keeps the structure intact.
More OOPS Concepts Questions
The result of a Cartesian product of two relations R and S will have:
Which command is used to remove all records from a table without deleting the table structure?
Which of the following is a valid constraint in SQL?
Which of the following is true about a view in SQL?
Which of the following prevents inheritance in C++?
What is early binding in the context of OOP?
Which of the following is used to eliminate redundancy and anomalies in a database?
Which SQL keyword is used to sort the result set?