English

Deepak wants to remove all rows from the tableBank. But he needs to maintain the structure of the table. Which command is used to implement the same?

Advertisements
Advertisements

Question

Deepak wants to remove all rows from the tableBank. But he needs to maintain the structure of the table. Which command is used to implement the same?

Code Writing
Advertisements

Solution

DELETE FROM tableBank;

This removes all records but retains the table structure.

shaalaa.com
  Is there an error in this question or solution?
Chapter 10: Structure Query Language - EXERCISE [Page 197]

APPEARS IN

CBSE Computer Science with Python [English] Class 12
Chapter 10 Structure Query Language
EXERCISE | Q 10. | Page 197
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×