Synonyms

[Dr_Destino 0]

Estou iniciando em SQL Server e gostaría de saber, como criar e como usar Synonyms

[eriva_br 7]

aqui tem alguns exemplos:

http://msdn2.microsoft.com/en-us/library/ms177544.aspx

http://www.developer.com/db/article.php/3613301

 

exemplo do books-online:

USE tempdb;GO-- Create a synonym for the Product table in AdventureWorks.CREATE SYNONYM MyProductFOR AdventureWorks.Production.Product;GO-- Query the Product table by using the synonym.USE tempdb;GOSELECT ProductID, Name FROM MyProductWHERE ProductID < 5;GO

Resultado:

ProductID   Name					  ----------- --------------------------1		   Adjustable Race2		   Bearing Ball3		   BB Ball Bearing4		   Headset Ball Bearings(4 row(s) affected)

bons estudos

t+