Tag: create synonym

Make sure you are using the correct database;

USE MyDatabase;
GO

Create a synonym as an alternate name for an existing object.

CREATE SYNONYM employees2 FOR MyDatabase.dbo.employees;

Reference the synonym in a query.

SELECT * FROM employees2;

Drop the synonym.

DROP SYNONYM employees2;

For more information see:

• CREATE SYNONYM (Transact-SQL)
• DROP SYNONYM (Transact-SQL)