How to delete records from self referencing table

Database
Enthusiast

How to delete records from self referencing table

Hi ,

I have a  table with self reference . how to empty the table???

Referencing column is a primary key.

Please suggest any solution.

Regards,

Arohi

1 REPLY
Enthusiast

Re: How to delete records from self referencing table

Create set table Dbase.cr ,no fallback,

no before journal,

no after journal,

checksum =default,

default blockratio

(

cr_id varchar(36) case specific not null,

name_l_id varchar(50),

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.