SCHEMA=

SCHEMA=

Enables you to read a data source, such as a DBMS table and view, in the specified schema.

Default value: None

Alias: OWNER=

Option type: LIBNAME and Data set

Syntax
Details
Example: Accessing a table using SCHEMA=

Syntax

SCHEMA=schema-name

Details

A schema is a logical classification of objects accessed by a data source, where the source is a relational database. For this option to work, you must have READ privileges to the schema that is specified. SCHEMA= is optional, and if omitted, you connect to the default schema.

Example: Accessing a table using SCHEMA=

In this example, SAS sends any reference to mydblib.emp as dbitest.emp.

libname mydblib oledb provider=sqloledb properties=('User ID'=sue 
        Password=mypw3) qualifier=hrdiv;
proc print data=mydblib.employees (schema=mitori);
run;

Chapter Contents
Previous
Next
Top of Page

Default value:	None
Alias:	OWNER=
Option type:	LIBNAME and Data set