728x90 AdSpace

Latest News

Powered by Blogger.

4.2.4 The DELETE statement


Deletes one or more tuples in a table according to given conditions

General form:

DELETE FROM

[ WHERE ];

Sample DELETE statements from the Case Example

Query 40: Deletes Customer record with Customer Number 004

DELETE FROM customers

WHERE cust# = 004;

DELETE FROM Ord_Items; <-------------------


Deletes all rows in Ord_Items Table. The table remains empty after the DELETE operation.

  • Blogger Comments
  • Facebook Comments

0 comments:

Post a Comment

Item Reviewed: 4.2.4 The DELETE statement Description: Rating: 5 Reviewed By: siteowner
Scroll to Top