what is synonym in sql ,what is it purpose [Resolved]

Synonyms

1)A synonyms is a single-part name which can replace multi part name in SQL Statement. Use of synonyms cuts down typing long multi part server name and can replace it with one synonyms. It also provides an abstractions layer which will protect SQL statement using synonyms from changes in underlying objects
2)A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.

Create Synonyms :
USE AdventureWorks;
GO
CREATE SYNONYM MyLocation
FOR AdventureWorks.Production.Location;
GO

Use Synonyms :
USE AdventureWorks;
GO
SELECT TOP 5 *
FROM MyLocation;
GO

Drop Synonyms :
USE AdventureWorks;
GO
DROP SYNONYM MyLocation;
GO

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

synonym is a duplicate name of table

server1: emp database name and employee table name

server2 acees this emp table is server1.emp.employee this access the table
select * from server1.emp.employee this access the table
wecan simple create synonym
CREATE SYNONYM S2.EMP FOR SERVER1.EMP.EMPLOYEE
simple select * from S2.EMP EXECUTE THE QUERY

Mahendra
91-9908699686

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

thanks nadh123 for ur ans.
can u explain bit more
like
1.what commands we can use on that and if we change the data in synonym ,then what what is effect on the original table
2.it purpose only to simply the name

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

original table effected the data

Mahendra
91-9908699686

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

and 2.purpose

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Please mark as answer if it helpful to you..That helps others who search the same..

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Good Work Muhsinathk

Thanks & Regards
Hari

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Thanks..

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

you can try the following links....
http://www.dbforums.com/microsoft-sql-server/1667196-how-create-synonym-view-entire-database-tables-view.html

Regards,
Vikash Pathak

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator