Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".
Gianmarco Brundo: "I have purchased SQLite Mestro and SQLite Data Wizard, your products are very good".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

  Return to chapter overview  

DELETE

sql-statement ::=

DELETE FROM table-name [WHERE expr]

The DELETE command is used to remove records from a table. The command consists of the "DELETE FROM" keywords followed by the name of the table from which records are to be removed.

 

Without a WHERE clause, all rows of the table are removed.

 

If a WHERE clause is supplied, then only those rows that match the expression are removed.



  Return to chapter overview