cascade delete
On v11.50.fc6, Aix 6 ... Got a table with a cascade delete on the RI. Does anyone know which system catalog contains this info. Can't seem to find this little piece of data ... Thanks in advance ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309
Peter Logan WROTE: >On v11.50.fc6, Aix 6 ... >Got a table with a cascade delete on the RI. Does anyone know which >system catalog contains this info. Can't seem to find this little piece >of data ... >Thanks in advance ... >Peter >Peter Logan >Senior Database Administrator >Phone: 616/878-8309 sysreferences delrule='C'
In sysreferences the delrule column contains 'C' for Cascade. The key is the constraint's contrid. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Apr 14, 2010 at 2:20 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > On v11.50.fc6, Aix 6 ... > > Got a table with a cascade delete on the RI. Does anyone know which > system catalog contains this info. Can't seem to find this little piece > of data ... > > Thanks in advance ... > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e68fc61101823404843a1443