Question

what is Synonyms?

Answer

A synonym is a database object that serves the following purposes:

Provides an alternative name for another database object, referred to as the base object, that can exist on a local or remote server.

Provides a layer of abstraction that protects a client application from changes made to the name or location of the base object.

Example:

CREATE TABLE SYNONYM_Temp

( id INT IDENTITY(1, 1), varName VARCHAR(50) )

CREATE SYNONYM Bank FOR SYNONYM_Temp

--Step :1

INSERT INTO Bank(varName)VALUES ('ICIC')

INSERT INTO Bank(varName)VALUES ('HSBC')

INSERT INTO Bank(varName)VALUES ('HDFC')

INSERT INTO Bank(varName)VALUES ('CITY')

SELECT * FROM Bank-->SYNONYM SELECT * FROM SYNONYM_Temp-->Origional Table

--Step :2

DELETE FROM Bank WHERE ID= 4

SELECT * FROM Bank

---Step :3

UPDATE Bank SET varName= 'CITY' WHERE ID= 3

SELECT * FROM Bank

---Step :4, you can not change the Structure of Table

ALTER TABLE bank ADD Col3 VARCHAR(50)

DROP SYNONYM Bank

Note: using SYNONYM You can Hide the origional definition of database object. Note: the name of a synonym must be unique. Note: You can create synonyms for database objects.

Read More..   [0 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·