Specifies which database objects to return with PROC DATASETS or in SAS Explorer.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | (TABLES VIEWS) This is set dynamically. |
| 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 |
Table of Contents
returns all database object names, which can slow performance. Specify ALL by itself. It always overrides any multiple values that you specify.
returns only public database synonym names.
returns only database synonym names.
returns only database table names.
returns only database view names.
DB_OBJECTS=(VIEWS SYNONYMS)