|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/5/2008 6:33:45 PM
Posts: 2,
Visits: 2
|
|
I am using Teradata SQL Assistant.
The SHOW TABLE provides only the structure of the table but NOT the table relationships like Primary Key and Reference Key.
Can you please let me know which is the command to get the structure and the KEY (relationship)
Thanks
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 1:34:04 PM
Posts: 117,
Visits: 238
|
|
Look at DBC.Indices view. The IndexType is set to K for Primary Key.
IndexType: Returns the type of an index as:
• P (Nonpartitioned Primary)
• Q (Partitioned Primary)
• S (Secondary)
• J (join index)
• N (hash index)
• K (primary key)
• U (unique constraint)
• V (value ordered secondary)
• H (hash ordered ALL covering secondary)
• O (valued ordered ALL covering secondary)
• I (ordering column of a composite secondary index)
• M (Multi-column statistics)
• D (Derived column partition statistics)
• 1 (field1 column of a join or hash index)
• 2 (field2 column of a join or hash index)
Also see dbc.ALL_RI_PARENTS, dbc.ALL_RI_Children views.
It is all explained in Data Dictionary manual.
Shaw
|
|
|
|