SCHEMA=

SCHEMA=

Specifies an alternative database to use when referring to a DBMS object. DATABASE= or DB= are aliases.

Default value: If you do not specify SCHEMA=, the default is the value of the SCHEMA= LIBNAME option.

Syntax
Details
Example: Accessing A Different User's Table

Syntax

SCHEMA=<'> alternate database<'>

<'> alternate database<'>: specifies a database name.

Details

The SCHEMA= option enables you to view or modify a different user's DBMS tables or views, assuming that you have the requisite Teradata privileges to that user's tables and views. For example, to read a different user's tables, you must have the Teradata privilege SELECT for that user's tables.

Example: Accessing A Different User's Table

libname mydblib teradata user=kamdar pw=ellis;
proc print data=mydblib.employees(schema=donna);
run;

In this example, user KAMDAR prints the contents of the EMPLOYEES table which is located in the DONNA database.

Chapter Contents
Previous
Next
Top of Page