Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql server synonym

CREATE SYNONYM <synonym_name, sysname, sample_synonym>
  FOR <schema_name, sysname, Production>.<object_name, sysname, Product>
GO

CREATE SYNONYM MyProductCatalog FOR [Azuredemodatabase].[SalesLT].[Product]

SELECT * FROM MyProductCatalog;
Source by codingsight.com #
 
PREVIOUS NEXT
Tagged: #sql #server #synonym
ADD COMMENT
Topic
Name
6+8 =