To determine the SCHEMA that is associated with a particular table or tables using SAS/ACCESS to OLE DB, you can submit the following code. When submitted, the SAS data set called WORK.TABS will contain a list of all tables the user has access to via OLE DB and the corresponding SCHEMA associated with each table:

proc sql;
connect to oledb;
create table TABS as select table_schema, table_name
from connection to oledb (OLEDB::Tables);
quit;

Operating System and Release Information