When you create a data source with v5 or later of StarSQL, the IncludeSynonyms support is enabled by default. Prior versions of StarSQL disabled IncludeSynonyms by default. For any StarSQL data source you can change the setting for the IncludeSynonyms support from the Expert Page of the Data Source Setup Wizard. If you enable or disable IncludeSynonyms, the setting for AllowSynonyms is forced to the same value, regardless of whether it was explicitly set.
When IncludeSynonyms is set to Yes, synonyms are supported, as both input and output, in catalog calls.
To disable Synonym support, set IncludeSynonyms to No on the Expert Page of the Data Source Setup Wizard. When AllowSynonyms or IncludeSynonyms is disabled, synonyms are not returned in results and are not found when passed as input parameters.
Enabling the SpecialColumns and IncludeSynonyms settings can enhance the use of StarSQL with some ODBC-enabled applications, such as Microsoft Query, as they can help the application with operations such as identifying join columns. These settings also can affect performance, depending on the applications and data involved, so you may need to experiment with the settings to determine which provide the best performance in your environment.