Using clause

Description

PostgreSQL lets you reference columns of other tables in the WHERE condition by specifying the other tables in the USING clause

Click here to navigate to the PostgreSQL documentation page for this syntax.

The USING clause is fully supported in Snowflake

Grammar Syntax

USING from_item [, ...]

This is an optional clause for the DELETE statement

Sample Source Patterns

PostgreSQL

DELETE FROM
         table1
using table1 a, table2 c
where a.name = c.name;

Snowflake

DELETE FROM
         table1
using table1 a, table2 c
where a.name = c.name;

Known Issues

No issues were found.

No related EWIs.

Last updated