|
|
Archives of the TeradataForum
Message Posted: Fri, 15 Nov 2002 @ 21:57:28 GMT
Subj: | | How to find foreign key relationship for a table in Teradata? |
|
From: | | Syed Arifuddin |
Hi,
I want to know, how to find foreign key relationship for a table in Teradata? Do i need to use data dictionary or to use any micro or
SP? The data dictionary table contains referencing table and referenced table id's instead of name,do u have any idea how can i map table
id's with table name?
Can any one provide me with script to perform this task,your help will be appreciated.
Thanks.
Syed Arifuddin.
| |