Search This Blog

Thursday, November 8, 2007

Synonym

Synonyms can be called as pointers used to call the objects or in simple word it is a alias named for objects like Tables,Views,Procedures & Functions.

Now synonyms are really useful where in the objects referrred can exist on same server in different database or different schema or even on a different server.

Syntax of how to create a synonym
Create Synonym Employee_Syn for ...Tablename

Using a synonym
Select * from Employee_Syn

No comments: