Monday, October 8, 2012

Synonyms is SQL Server 2005

Synonyms are the another name of table.like alias name in T-SQL synonyms are permanent.
It is very Easy to create synonyms.Two ways we can create synonyms.
Either by using T-SQL or by using SSMS(SQL server management studio).

Syntax:

CREATE SYNONYM AdPerson
  FOR
[AdventureWorks2012].[Person].[Address]

No comments: