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)