SQL
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.