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.

Syntax

SHOW SYNONYMS [ IN schemaName ] 

schemaName

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

Results

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

Examples

splice> show synonyms;
TABLE_SCHEM  |TABLE_NAME         |CONGLOM_ID|REMARKS
---------------------------------------------------------------
SPLICE       |HITTING            |NULL      |

1 rows selected