Primary and Foreign Key relationship

Tools & Utilities

Primary and Foreign Key relationship

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
1 REPLY
Enthusiast

Re: Primary and Foreign Key relationship

u can use following query

show sel * from tablename;