I want to truncate data.
1. So i do ALTER TABLE table1 NOCHECK CONSTRAINT ALL
2. 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.
Any help is greatly appreciated.