SHOW_SYNONYMS= LIBNAME Option

Specifies whether PROC DATASETS shows synonyms, tables, views, or materialized views for the current user and schema if you specified the SCHEMA= option.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	YES
Restriction:
Data source:	Oracle
See:	DBLINK= LIBNAME option, DB_OBJECTS= LIBNAME option

Syntax

Details

Syntax

SHOW_SYNONYMS=<YES | NO>

Syntax Description

YES: specifies that PROC DATASETS shows only synonyms that represent tables, views, or materialized views for the current user.

NO: specifies that PROC DATASETS shows only tables, views, or materialized views for the current user.

Details

Rather than submit PROC DATASETS, you can select the libref in SAS Explorer to obtain this same information. By default, no PUBLIC synonyms are displayed unless you specify SCHEMA=PUBLIC.

When you specify only the SCHEMA option, the current schema is always displayed with the appropriate privileges.

Tables, views, materialized views, or synonyms on the remote database always are displayed when you specify the DBLINK= LIBNAME option. If a synonym represents an object on a remote database that you might not be able to read, you might receive an Oracle error. An example is a synonym representing a sequence.

Synonyms, tables, views, and materialized views in a different schema are also displayed.