Promotic
WikipediaLinkedInYoutubeTwitterFacebook

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 a comma).
search_condition Logical expression determining which rows of the source table have to be included into deleting (if WHERE is not stated, 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
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice