DELETE FROM table_name [ [ AS ] alias ][ WHERE booleanExpression ]
table_identifier
: Table name in the three-part format. Example: catalog.database.table.DELETE FROM lineitem WHERE shipmode = 'AIR';DELETE FROM lineitemWHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');DELETE FROM orders;
Was this page helpful?