SQL Reference Guide > SQL Statements > CREATE SYNONYM > CREATE SYNONYM Examples
Was this helpful?
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;
Last modified date: 01/27/2026