Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for Delphi 5 » SQL Reference » DELETE Statement |
DELETE FROM table_reference [AS correlation_name | correlation_name] [EXCLUSIVE] [[INNER | [LEFT | RIGHT] OUTER JOIN] table_reference [AS correlation_name | correlation_name] [EXCLUSIVE] ON join_condition] [WHERE predicates] [COMMIT [INTERVAL commit_interval] FLUSH] [NOJOINOPTIMIZE] [JOINOPTIMIZECOSTS] [NOWHEREJOINS]
FROM table_reference [AS correlation_name | correlation_name] [EXCLUSIVE]
DELETE FROM orders INNER JOIN customer ON customer.custno=orders.custno WHERE customer.country='Bermuda'
DELETE FROM orders o INNER JOIN customer c ON c.custno=o.custno WHERE c.country='Bermuda'
WHERE predicates
DELETE FROM SalesInfo WHERE (State='CA')
COMMIT [INTERVAL nnnn] [FLUSH]
NOJOINOPTIMIZE
JOINOPTIMIZECOSTS
NOWHEREJOINS
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |