DELETE Statement

Help Contents

DELETE Statement

The DELETE statement deletes one or more rows in a database table. The format of the DELETE statement is:

delete-statement ::=
  DELETE FROM table-name
  [WHERE search-condition ]


The SQL DELETE Statement can only be used to remove rows from a Database Table Tag.

The table-name must be qualified by the schema name DatabaseTable.


  1. Delete all rows from a Database Table Tag:
    DELETE FROM DatabaseTable.DailySummary

Further Information

ODBC driver

To learn about the ODBC driver in Fernhill SCADA.

SQL Test Tool

To learn about the SQL Test Tool.


For the meaning of terms used in Fernhill SCADA.