SQL Synonym

05-Oct-1212 Leave a comment

During study for Exam 70-461 looked at Synonym

Could be useful. For instance could use synonym to point at a data table in linked “Live” database. Then restore your project to “Test” version, change the synonym to point at the linked “Test” database and you have changed what all objects now point at.

http://blog.sqlauthority.com/2008/01/07/sql-server-2005-introduction-and-explanation-to-synonym-helpful-t-sql-feature-for-developer/

 

Filed under Transact SQL

Leave a comment