Data Warehouse & Business Intelligence
MSBI and other knowledge base
Labels
ASP.Net
(1)
BIML
(4)
Business Intelligence
(1)
C#
(8)
Data Models
(1)
Data Types
(1)
Data Warehouse
(3)
Database Architecture
(1)
Database Management
(1)
Date Functions
(3)
ERD
(2)
Google Analytics
(4)
MobileApp Analytics
(1)
OoyalaAPI
(4)
Reference Sites
(1)
SalesForce
(4)
Scenarios
(6)
Script
(27)
SQL
(8)
SQL Job
(3)
SSAS
(2)
SSIS
(36)
SSRS
(4)
StoredProcedure
(8)
StoredProcedureFunction
(1)
T-SQL
(60)
Tableau
(1)
What's new
(1)
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.
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.