CODEWITHSUNDEEP
sql-serversql-server-2005synonym
Abdullah
Abdullah

Reputation: 5575

Error when creating Synonym in SQL Server 2005 with the same table name

I want to create Synonym for a table , so all the other users in this database use this Synonym instead of writing databasename.schema.table , but when I write :

CREATE SYNONYM [ACCT_STMT] FOR [AccountStatementPRD].[dbo].[ACCT_STMT]
GO

it generates an error msg :

There is already an object named 'ACCT_STMT' in the database. Msg 4606,

in oracle , I can create Synonym with the same table name !

Upvotes: 0

Views: 1092

Answers (1)

Kris Ivanov
Kris Ivanov

Reputation: 10598

if all you want is to use it by name only, and you already executing the statment in the correct DB, you don't have to use databasename.schema.tablename, just use tablename

for example, instead of

SELECT * FROM [AccountStatementPRD].[dbo].[ACCT_STMT]

you can just do

SELECT * FROM [ACCT_STMT]

as far as having the same name for synonym, that will not work in the same DB

Upvotes: 1

Related Questions