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]
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:
Post a Comment