Oracle synonyms are not shown when you are using SAS/ACCESS® Interface to ODBC


By default, Oracle synonyms are not shown by the LIBNAME engine with SAS/ACCESS Interface to ODBC®. To show synonyms, simply add the option below option to your LIBNAME statement:

PRESERVE_TAB_NAMES=YES