Deleting Rows

The syntax for deleting rows from tables using sql commands.

SYNTAX :

        Delete from <Table_name>
         where <search_condition>

WHERE :
     <Table_name> is the name of the table from which the records are deleted.
     Where clause is used to specify the condition. If WHERE clause is not included in the
DELETE statement, all the records in the table will be deleted.

Example :
     
   DELETE  FROM  Flight_master
   WHERE Aircode='AI'

Execute that command.

Result:

Command(s) completed successfully.