SCHEMA=

SCHEMA=

Enables you to read database objects, such as tables and views, in the specified schema

Default value: None

Alias: OWNER=

Syntax
Details
Example: Accessing a table using SCHEMA=

Syntax

SCHEMA=schema-name

Details

A schema is a logical classification of objects in a database. You must have read privilege to the schema that is specified for this option to work. The SCHEMA= option is optional. If it is omitted, you connect to the default schema.

Example: Accessing a table using SCHEMA=

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

libname mydblib odbc user=testuser pwd=testpass
dsn=oracle;
proc print data=mydblib.employees (schema=dbitest);
run;

Chapter Contents
Previous
Next
Top of Page