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 Client never know what is origional table Name.
Tags: