I am currently working on pulling down metadata from a given Teradata database and have run into a problem. I have figured out how to pull all the tables/columns/views/stored procedures of a given database, but now I need to pull all the primary/foriegn key relationships down. All I need is the proper select to do such a thing.
Something to keep in mind, I only have read access to the databases I am working with. If no relationships exist, that is fine, but I need to pull any and all that do.