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: codingsight.com

Similar codes

0 vote98 views1 answer
Monthly Birthday SQL Query
SQL
10 votes105 views2 answers
Reset mysql root password mac
SQL
0 vote130 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
16 votes97 views4 answers
Mysql import from sql file
SQL
1 vote119 views1 answer
Postgres cast as currency format
SQL
0 vote98 views1 answer
Update top 100 sql
SQL
0 vote96 views1 answer
Database xml sql
SQL
4 votes98 views1 answer
Select nls_date_format
SQL
2 votes137 views1 answer
How to select from mssql
SQL
31 votes108 views4 answers
How to get duplicate records with multiple field in sql
SQL