![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for Developer Studio 2006 (C++) » 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 Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |