Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help

create a synonym in a "To Schema" for each Table in the "From Schema"

File Details
Downloads: 375 File Size: 3.4kB
Posted By: admin Views: 629
Date Added: Mon, Mar 31 2008

This script will create a synonym in a "To Schema" for each Table in the "From Schema" (if it doesnt already exist).  You should edit the FromSchemaName and ToSchemaName before running the script.

 To run it:

1) bring up the Script Explorer

2) right click on "User Defined" and select "New Script"

3) copy/paste the attachment into the edit control

4) hit the run button (the first icon in the toolbar above the edit control)

Note: you can undo/redo the effects of this script as with any Model changes

Comments
No comments exist for this file.

Add Comment

Name (required)
Web Site (optional)
Comment (required)
Add