This can be used to delete the table data temporarily.
Syntax:
Delete <table_name> where <condition>;
Example:
SQL> DELETE student;
If you are not specifying any condition this will delete entire table.
SQL> DELETE Student WHERE no = 2;
0 comments:
Post a Comment