https://communities.sas.com/t5/SAS-Programming/Connect-sql-to-SAS-Not-all-tables-showing/m-p/342723#M272877 <P>How long are the table names? Over 32 chars?</P> Mon, 20 Mar 2017 19:02:22 GMT Reeza 2017-03-20T19:02:22Z https://communities.sas.com/t5/SAS-Programming/Connect-sql-to-SAS-Not-all-tables-showing/m-p/342711#M272876 <P>Hi,</P><P>I successfully connected SAS with Sql server but am seeing &nbsp;only a couple of tables in the schema, some are missing and are not in the list? Any insights??</P><P>&nbsp;</P><P>libname study odbc datasrc=&nbsp;datasrcname<BR />prompt=yes<BR />schema = dbo<BR />user =&nbsp;<BR />password =&nbsp;<BR />multi_datasrc_opt = IN_CLAUSE;</P><P>&nbsp;</P><P>Thank you</P> Mon, 20 Mar 2017 18:01:55 GMT https://communities.sas.com/t5/SAS-Programming/Connect-sql-to-SAS-Not-all-tables-showing/m-p/342711#M272876 AZIQ1 2017-03-20T18:01:55Z https://communities.sas.com/t5/SAS-Programming/Connect-sql-to-SAS-Not-all-tables-showing/m-p/342723#M272877 <P>How long are the table names? Over 32 chars?</P> Mon, 20 Mar 2017 19:02:22 GMT https://communities.sas.com/t5/SAS-Programming/Connect-sql-to-SAS-Not-all-tables-showing/m-p/342723#M272877 Reeza 2017-03-20T19:02:22Z