I have a table with self reference . how to empty the table???
Referencing column is a primary key.
Please suggest any solution.
Create set table Dbase.cr ,no fallback,
no before journal,
no after journal,
cr_id varchar(36) case specific not null,
parent_cr_id varchar(50) ,
primary key (cr_id),
constaint forign_key (name_l_id) references dbase.l(l_id),
constraint foreign_key(parent_cr_id) references dbase.cr(cr_id))
This is the ddl of my self ref table.