https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37515#M9547 Hi!<BR /> <BR /> I have one libname(SQL Server) assigned and when i enter it's clear.<BR /> <BR /> How can i see the tables in it?<BR /> <BR /> What dictionary i search this tables? Wed, 06 Jan 2010 13:54:10 GMT deleted_user 2010-01-06T13:54:10Z https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37515#M9547 Hi!<BR /> <BR /> I have one libname(SQL Server) assigned and when i enter it's clear.<BR /> <BR /> How can i see the tables in it?<BR /> <BR /> What dictionary i search this tables? Wed, 06 Jan 2010 13:54:10 GMT https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37515#M9547 deleted_user 2010-01-06T13:54:10Z https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37516#M9548 Recommended Google advanced search argument: <BR /> <BR /> dictionary tables site:sas.com<BR /> <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 06 Jan 2010 16:01:08 GMT https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37516#M9548 sbb 2010-01-06T16:01:08Z https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37517#M9549 when you assign through SAS/Access to ODBC, ensure you add the parametrer <BR /> schema= <BR /> with whatever your database administrator has set up as the "name space". For example, a recent client used<BR /> schema=dbo Fri, 08 Jan 2010 14:43:09 GMT https://communities.sas.com/t5/SAS-Procedures/BEGINER-How-can-i-see-the-tables-in-my-sql-libname/m-p/37517#M9549 Peter_C 2010-01-08T14:43:09Z