Dependencies between the tables.

Database
Enthusiast

Dependencies between the tables.

Hi All

I want teradata sql query to find out the dependencies between tables in a particular database with respect to their constraints.

what are the constraints defined for a table and how that table is related to other tables in that database?

Can anyone please help in this regard?

Thanks
Dileep
1 REPLY
Teradata Employee

Re: Dependencies between the tables.

Hello,

If you are looking for Referential Integrity (Foreign Key Constraints) or Table Level Constraints, you can surely find related tables/views in DBC.

HTH.

Regards,

Adeel