Please help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ...

Teradata Applications
Enthusiast

Please help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ...

Hi All,

Please help me suggesting a query to find

                                                                 1.the scale of the column in teradata

                                                                 2.the foreign keys of a table in teradata

                                                                 3.the association between two tables in teradata

Thanks in advance !

Regards,

Vandy :)

3 REPLIES
Enthusiast

Re: Please help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ...

Can someone please reply to my post.

Do let me know if you need any additional information.

Junior Supporter

Re: Please help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ...

1: SELECT DBC.COLUMNS.

2 & 3: SELECT  DBC.ALL_RI_PARENTS AND / OR  DBC.ALL_RI_CHILDREN.

HTH.

Cheers.

Carlos.

Enthusiast

Re: Please help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ...

thanks Carlos :)