SQLite Code Factory online Help

Return to chapter overview

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

SQL Maestro Group wish you a Merry Christmas!

We're happy to grant you a 20% discount for all our products and bundles till December 31!

News

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Feature of the day

Data Export

With SQLite Code Factory you can also export result sets to as many as 14 file formats including Excel, RTF and HTML.

Visual Query Builder

SQLite Code Factory allows to design queries as visual diagrams.

SQLite Code Factory online Help

DELETE

Christmas Sale