List SoftRI Tables and HardRI Tables

Database

List SoftRI Tables and HardRI Tables

Hi,
On dbms 15.10 is there any dbc table or quicker way to get the list of SoftRI Tables and HardRI tables seperately?

There are dbc tables like dbc.constraintnames and dbc.referecingTbls, but we cannot get the complete constraint statement to see whether it is soft RI or hard RI.



Thanks,
Geeta.

GeetaKudumula
2 REPLIES
Junior Contributor

Re: List SoftRI Tables and HardRI Tables

Afaik, no.

Re: List SoftRI Tables and HardRI Tables

I wish TD introduce something in DBMS 16/16.10.

Thank you Dieter.

GeetaKudumula