# E101-04: Searched DELETE statement

statement ok
CREATE TABLE TABLE_E101_04_01_01 ( ID INT PRIMARY KEY, A INT, B INT );

statement ok
INSERT INTO TABLE_E101_04_01_01 VALUES ( 0, 1, 2 );

statement ok
DELETE FROM TABLE_E101_04_01_01

statement ok
CREATE TABLE TABLE_E101_04_01_02 ( ID INT PRIMARY KEY, A INT, B INT );

statement ok
INSERT INTO TABLE_E101_04_01_02 VALUES ( 0, 1, 2 );

statement ok
DELETE FROM TABLE_E101_04_01_02 WHERE A = 1
