Following is the synonym creation syntax.
CREATE SYNONYM synonym-name FOR authorization-name.table-name [authorization-name.view-name] |
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!