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;