statement ok
CREATE TABLE kanto.myschema.mytable (a BIGINT NOT NULL, b BIGINT, PRIMARY KEY(a));

statement ok
INSERT INTO kanto.myschema.mytable (a, b) VALUES (42, 7), (13, 34);

statement ok
DELETE FROM kanto.myschema.mytable;

query I rowsort
SELECT * FROM kanto.myschema.mytable;
----

query I rowsort
SELECT count(*) FROM kanto.myschema.mytable;
----
0