CREATE TABLE DeleteTest ( Col1 VARCHAR(10) NOT NULL, 
                          CONSTRAINT DeleteTest_PK PRIMARY KEY (Col1));

UPSERT INTO DeleteTest (Col1)
VALUES ('1');


SELECT COUNT(*)
FROM DeleteTest
WHERE Col1 = '1';


DELETE
FROM DeleteTest
WHERE Col1 = '1';


SELECT COUNT(*)
FROM DeleteTest
WHERE Col1 = '1';


DELETE
FROM DeleteTest
WHERE Col1 = '1';


DROP TABLE DeleteTest;