All Forums Teradata Applications
vandy 6 posts Joined 01/13
31 Jan 2013
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 :)
 

vandy 6 posts Joined 01/13
31 Jan 2013

Can someone please reply to my post.
Do let me know if you need any additional information.

CarlosAL 512 posts Joined 04/08
01 Feb 2013

1: SELECT DBC.COLUMNS.
2 & 3: SELECT  DBC.ALL_RI_PARENTS AND / OR  DBC.ALL_RI_CHILDREN.
HTH.
Cheers.
Carlos.

vandy 6 posts Joined 01/13
03 Feb 2013

thanks Carlos :)

You must sign in to leave a comment.