Promotic

DELETE - statement of language DB_MSSQL

Description:
Delete rows in the table.
Syntax:

DELETE FROM table_source
[ WHERE search_condition ]

table_source List of tables used in the query (tables separated by comma).
search_condition Logical expression determining which rows of the source table have to be included into deleting (if WHERE is not stated, then it means all records).
See also:
Example1:
Delete all records from the table data.
DELETE FROM data
Example2:
Delete records that meet the specified condition from the table data. Both notations are equivalent.
DELETE FROM data WHERE value > 20 AND value < 80
DELETE FROM data WHERE value BETWEEN 20 AND 80
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.