8. SQL Statements
:
CREATE SYNONYM
:
CREATE SYNONYM Examples
Share this page
CREATE SYNONYM Examples
1.
Create a synonym for the authors table.
CREATE SYNONYM writers FOR authors;
2.
Create a synonym for the composers table, owned by another user.
CREATE SYNONYM cmp FOR tony.composers;