ODBC Connection to SSMS. Schema Question

mcook — Tue, 09 Mar 2021 14:31:17 GMT

I am connecting to SSMS via ODBC using the following code

libname mylib odbc noprompt = "driver = ODBC Driver 11 for SQL Server;
                             server = Server_Name;
                             database = Database_Name;
                             Trusted_Connection = yes"
                 schema = Schema1;

If i'm only interested in the tables in schema1, schema2 and schema3,

is it possible to get all 3 schemas into one library? or am i limited to having an individual library for each schema?

Re: ODBC Connection to SSMS. Schema Question

ChrisNZ — Fri, 12 Mar 2021 01:01:36 GMT

You can create a compound library.

libname LIB1 odbc ... schema = Schema1; libname LIB2 odbc ... schema = Schema2; libname LIB3 odbc ... schema = Schema3; libname LIB4 (LIB1 LIB2 LIB3);

topic ODBC Connection to SSMS. Schema Question in SAS Programming

ODBC Connection to SSMS. Schema Question

Re: ODBC Connection to SSMS. Schema Question