How can i get Information about table columns from TableSynonym.
getColumns name in DatabaseMetadata returns empty result set for tableSynonyms.
because of security restrictions and for easy database maintainence i should not use table names itself.
I am using following method to check number of columns in Table synonym.
passing tableSynonym for tableName pattern argument.
getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
Retrieves a description of table columns available in the specified catalog.
Do you guys suggest any work around to get Columns associated with real table from its synonym.