DELETE - statement of language DB_MSSQL

Delete rows in the table.

DELETE FROM table_source

[ WHERE search_condition ]

table_source	List of tables used in the query (tables separated by a 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).

Delete all records from the table data.

DELETE FROM data

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.14 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remark Contact responsible person