Show TOC

Example documentationSYNONYMS

 

Use of the system table DOMAIN. SYNONYMS

Prerequisites

You can use the demo data for the SQL tutorial. Start the Database Studio as database administrator MONA with the password RED and log on to demo database DEMODB: Logging On to a Database.

Define synonyms. To do this, use the CREATE SYNONYM Statement (create_synonym_statement).

Activities

You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview

Note the General Instructions for formulating SQL statements.

You can use the system table SYNONYMS to determine the following database information, among other things:

  • The table (basis table, view table) for which the PUBLIC synonym SHORT_TAB was defined

    SELECT tableowner, tablename

    FROM DOMAIN.SYNONYMS

    WHERE public = 'YES'

    AND synonymname = 'SHORT_TAB'

  • Private synonym for the CITY table of the database user MONA

    SELECT synonymname

    FROM DOMAIN.SYNONYMS

    WHERE tableschemaname = 'HOTEL'

    AND tableowner = 'MONA'

    AND tablename = 'CITY'

More Information

Existence of a synonym: see TABLES