LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 23 Jan 2008 15:58:02 -0800
Reply-To:   "Richard A. DeVenezia" <richard.google@DEVENEZIA.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Richard A. DeVenezia" <richard.google@DEVENEZIA.COM>
Organization:   http://groups.google.com
Subject:   Re: How to lookup the relationships between tables in a database
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset=ISO-8859-1

On Jan 23, 9:07 am, vatodorov <vatodo...@gmail.com> wrote: > Is it possible to lookup the relationships between tables in an SQL > database? I wrote a code that queries the server and returns a list > with all the tables there, but I don't know how they are related. I > would like to expand that and lookup the relationships and the > variables by which they are connected.

Try SASHELP.VREFCON

REFCON -> Referential Constraints

-- Richard A. DeVenezia http://www.devenezia.com

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu