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 ]

Remarks

The 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.

Examples

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

Further Information

.NET Framework Data Provider

To learn about the .NET Framework Data Provider in Fernhill SCADA (FernhillSoftware.Data.FernhillScadaClient).

ODBC driver

To learn about the ODBC driver in Fernhill SCADA.

SQL Test Tool

To learn about the SQL Test Tool.

Glossary

For the meaning of terms used in Fernhill SCADA.