DB_OBJECTS= LIBNAME Option

Specifies which database objects to return with PROC DATASETS or in SAS Explorer.
Valid in: SAS/ACCESS LIBNAME statement
Default: (TABLES VIEWS)
Restriction: Because SHOW_SYNONYMS=YES overrides DB_OBJECTS= and is available only for backward compatibility, you should instead use DB_OBJECT=SYNONYMS.
Data source: Oracle
See: SHOW_SYNONYMS= LIBNAME option

Syntax

DB_OBJECTS=(TABLES | VIEWS | SYNONYMS | ALL)

Syntax Description

TABLES
returns only database table names.
VIEWS
returns only database view names.
SYNONYMS
returns only database synonym names.
ALL
returns all database object names, which can slow performance. Specify ALL by itself. It always overrides any multiple values that you specify.

Example: Specify Multiple Objects

DB_OBJECTS=(VIEWS SYNONYMS)