If this option is omitted, you connect to the default
schema for your data source.
The values for SCHEMA=
can be case-sensitive, depending on the data source, so use care when
you specify this option. You should set PRESERVE_TAB_NAMES=YES when
the value for SCHEMA= contains mixed case characters.
Oracle
Details: Specify a schema name to be used when
referring to database objects. SAS can access another user's database
objects by using a specified schema name. If PRESERVE_TAB_NAMES=NO,
SAS converts the SCHEMA= value to uppercase because all values in
the Oracle data dictionary are uppercase unless quoted.
Teradata
Details: If you omit this option, a libref points
to your default Teradata database, which often has the same name as
your user name. You can use this option to point to a different database.
This option enables you to view or modify a different user's DBMS
tables or views if you have the required Teradata privileges. (For
example, to read another user's tables, you must have the Teradata
privilege SELECT for that user's tables.) The Teradata alias for SCHEMA=
is DATABASE=. For more information about changing the default database,
see the DATABASE statement in your Teradata documentation.