I assume your question relates to referential integrity .... you can use following objects to get desired information:

DBC.All_RI_Children -> defined referential constraints from the child-parent perspective.

DBC.All_RI_Parents -> defined referential constraints from the parent-child perspective.

DBC.RI_Child_Tables -> tables in child-parent order. This view is similar to the All_RI_Children view, but returns the internal IDs of databases, tables, and columns.

DBC.RI_Distinct_Children -> tables in child-parent order without the duplication that could result from multi-column FKs.

DBC.RI_Distinct_Parents -> tables in parent-child order without the duplication that could result from multi-column FKs.

DBC.RI_Parent_Tables -> tables in parent-child order. This view is similar to the All_RI_Parents view, but returns the internal IDs of databases, tables, and columns.

HTH!

From parent persective:

select * from DBC.All_RI_Children
where ParentTable = '<ur_parent_table>'

select * from DBC.All_RI_Parents
where ParentTable = '<ur_parent_table>'

select * from DBC.RI_Distinct_Children
where ParentTable = '<ur_parent_table>'

select * from DBC.RI_Distinct_Parents
where ParentTable = '<ur_parent_table>'

Depending what kind of information you need to extract from these tables/views.

Hi Sai,

if you don't get an answer set there's probably no Foreign Key defined within your Create Table.

Then PK/FK relations are unknown to Teradata, you have to consult your logical model.

Dieter