Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Tuesday, 11 April 2017

SQL Table Data Delete


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;
Share this article :

0 comments:

Post a Comment