1. So i do ALTER TABLE table1 NOCHECK CONSTRAINT ALL2. Then i do TRUNCATE TABLE table1 3. Then i get an error java.sql.SQLException: Cannot truncate table 'table1 ' because it is being referenced by a FOREIGN KEY constraint.

The table has cyclic reference.i.e it has an primary key id which is an foreign key in the next row.