DB2 - SQL Create Synonym Statement

Following is the synonym creation syntax.

CREATE SYNONYM synonym-name
    FOR authorization-name.table-name
        [authorization-name.view-name]

Example:

Create a synonym for a table DSN8910.TB_DEPT.

CREATE SYNONYM SN_DEPT
    FOR DSN8910.TB_DEPT;

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!