Delete From a Table

Description

The DELETE statement removes rows that fulfill the WHERE clause criteria.

Syntax

Here is the syntax:

DELETE FROM integration_name.table_name
WHERE column_name = column_value_to_be_removed;

This statement removes all rows from the table_name table (that belongs to the integration_name integration) wherever the column_name column value is equal to column_value_to_be_removed.

And here is another way to filter the rows using a subquery:

DELETE FROM integration_name.table_name
WHERE column_name IN
                    (
                        SELECT column_value_to_be_removed
                        FROM some_integration.some_table
                        WHERE some_column = some_value
                    );

This statement removes all rows from the table_name table (that belongs to the integration_name integration) wherever the column_name column value is equal to one of the values returned by the subquery.