Azure Data Studio - View/create synonym

Question

Hi,

Is there a way to view/create a synonym in Azure Data Studio just like it can be done in SSMS?

Thanks
Stéphane

Answer 1

Hi @sroy2022 ,

Azure Data Studio and SQL Server Management Studio are two visualization tools. Although there are many similarities, they are always different. Although ADS is gradually becoming more popular. But it is not yet as powerful as SSMS in querying data. When you want to use Synonyms, it is recommended that you use SSMS in addition to T-SQL statements.
You can start reading here, and there is a navigation bar on the left side for you to know your current location.
Synonyms (Database Engine)

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

just execute the query:

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-synonym-transact-sql?view=sql-server-ver16

Answer 3

Hi,

I know about it about this command.

It's just that it's very annoying trying to figure out the content. I must switch to SSMS all the time. The DBs I must investigate contain hundreds of synonyms.

I guest I'll have to create a project and then look at the synonym.

Thanks

Answer 4

If you want to view what synonyms there are, and their definitions, use the catalog view sys.synonyms.

Answer 5

Here are some examples with full-text indexing that you can continue to explore on your own. Key takeaway is that you can create a full-text index on multiple columns

The version with FULLTEXTTABLE seems the most promising to me.

   CREATE TABLE ProductsAndBrands (ix  int NOT NULL,  
                                   Brand nvarchar(40) NOT NULL,  
                                   Product nvarchar(40) NOT NULL,  
                                   CONSTRAINT pk_ProductsAndBrands PRIMARY KEY (ix)  
   )  
   go  
   INSERT ProductsAndBrands(ix, Brand, Product)  
     VALUES(1, 'Samsung', 'Galaxy S21'),  
           (2, 'Samsung', 'QN95B Neo QLED 4K'),  
           (3, 'Volvo',   'P1800'),  
           (4, 'Volvo',   'Amazon')  
   go  
   CREATE FULLTEXT CATALOG cattie AS DEFAULT  
   go  
   CREATE FULLTEXT INDEX ON ProductsAndBrands(Brand, Product) KEY INDEX pk_ProductsAndBrands  
   go  
   WHILE EXISTS (SELECT * FROM sys.fulltext_indexes WHERE has_crawl_completed = 0)  
      WAITFOR DELAY '00:00:00.100'  
   go  
   SELECT * FROM ProductsAndBrands WHERE CONTAINS(*, '"Samsung Galaxy"')  
   SELECT * FROM ProductsAndBrands WHERE CONTAINS(*, '"Amazon Volvo"')  
   SELECT * FROM ProductsAndBrands WHERE CONTAINS(*, '"Samsung P1800"' )  
     
   SELECT * FROM ProductsAndBrands WHERE FREETEXT(*, '"Samsung Galaxy"')  
   SELECT * FROM ProductsAndBrands WHERE FREETEXT(*, '"Amazon Volvo"')  
   SELECT * FROM ProductsAndBrands WHERE FREETEXT(*, '"Samsung P1800"' )  
     
     
   SELECT PAB.Ix, PAB.Brand, PAB.Product, ft.RANK  
   FROM   ProductsAndBrands PAB  
   JOIN   FREETEXTTABLE(ProductsAndBrands, *, '"Samsung Galaxy"') ft ON ft."KEY" = PAB.ix  
   ORDER BY ft.RANK DESC  
     
   SELECT PAB.Ix, PAB.Brand, PAB.Product, ft.RANK  
   FROM   ProductsAndBrands PAB  
   JOIN   FREETEXTTABLE(ProductsAndBrands, *, '"Amazon Volvo"') ft ON ft."KEY" = PAB.ix  
   ORDER BY ft.RANK DESC  
     
     
   SELECT PAB.Ix, PAB.Brand, PAB.Product, ft.RANK  
   FROM   ProductsAndBrands PAB  
   JOIN   FREETEXTTABLE(ProductsAndBrands, *, '"Samsung P1800"') ft ON ft."KEY" = PAB.ix  
   ORDER BY ft.RANK DESC  
   go  
   DROP TABLE ProductsAndBrands  
   DROP FULLTEXT CATALOG cattie