Show Synonyms

The show synonyms command displays all of the synonyms that have been created with the CREATE SYNONYM statement in the database or specified schema.


SHOW SYNONYMS [ IN schemaName ] 


If you supply a schema name, only the synonyms in that schema are displayed; otherwise, all synonyms in the database are displayed.


The show synonyms command results contains the following columns:

Column Name Description
TABLE_SCHEMA The name of the synonym's schema
TABLE_NAME The name of the table
CONGLOM_ID The conglomerate number, which points to the corresponding table in HBase
REMARKS Any remarks associated with the table


splice> show synonyms;
SPLICE       |HITTING            |NULL      |

1 rows selected