Wednesday, June 6, 2012

SQL Script to Create Synonyms


Script to create Synonyms for different data base


USE [xxx]   --DB Name
GO
CREATE SYNONYM [scheman_name].[s_tablename] FOR [*DB_name*].[schema_name].[table_name]
GO


**DB_name* - Here provide database Name for which we do create synonym

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.