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