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 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 17 Jan 2002 06:11:48 -0500
Reply-To:     Simon Pickles <simon.pickles@BARCAP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Simon Pickles <simon.pickles@BARCAP.COM>
Subject:      Re: MS ACCESS TO SAS: how to get list of ALL tables

More generally, to get the list of tables in any ODBC source use the ODBC::SQLTables "object". Also ODBC::SQLColumns is available.

PROC SQL; CONNECT TO ODBC (PROMPT); %put &sqlxmsg; /*prints connection parameters to the log */

CREATE TABLE OdbcTables AS SELECT * FROM CONNECTION TO ODBC (SELECT * FROM ODBC::SQLTables) ; quit;

I got this off SAS.COM a while ago but it's invaluable for checking database contents.

Simon


Back to: Top of message | Previous page | Main SAS-L page