SYNONYMs in SQL Server

SYNONYM OBJECT:

SYNONYM OBJECT IS USED TO CREATE THE permanent ALIAS NAME for single base table.
IT IS USED TO HIDE THE ORIGINAL NAME OF AN OBJECT.IT IS USED TO CREATE THE SECURITY  OF THE TABLE.

it supports DML AND DQL OPERATIONS.

Note: if any changes in the synonym automatically reflected into base table and viceversa.


SYNTAX:
CREATE SYNONYM <SYNONYMNAME> FOR <TABLENAME>

SELECT * FROM EMP
CREATE SYNONYM S1 FOR EMP
SELECT * FROM S1
DELETE FROM S1 WHERE ENO=101

DELETE FROM S1 WHERE ENO=101

DROP SYNONYM S1
SELECT * FROM S1

select * from sys.synonyms
where base_object_name='[emp]'

SELECT * FROM INFORMATION_SCHEMA.VIEWS

DIFFERENCE BETWEEN VIEW AND SYNONYM:
    VIEW                                                                           SYNONYM
1.VIEW IS A SUBSET OF TABLE                            1.SYNONYM IS A MIRROR OF A TABLE.
2.VIEW CAN BE BASED ON MORE                      2.SYNONYM IS ALWAYS BASED ON
THAN ONE TABLE                                                       ONLY ONE TABLE.

Thanks
GSV