Foreign Key

Database
Enthusiast

Foreign Key

hi,
is there a way to find out whether a table is defined with a foreign key or not???

I know that one way is to look up the table definition, but i wanted some other means to check if its defined with FK constraints

Thanks in advance
Rajan
2 REPLIES
Teradata Employee

Re: Foreign Key

Hello,

If you have select rights on DBC, please have a look at all views starting with "RI_".

Regards,

Adeel
Enthusiast

Re: Foreign Key

Hi,
Thanks a lot....
Rajan