Can synonyms be encrypted

No, SQL Server synonyms cannot be encrypted because they only store metadata references, not executable definitions. There is no WITH ENCRYPTION option available when creating a synonym. A synonym is just a metadata alias not executable code. There are no SQL body and no module definition so nothing to encrypt. Encryption is unsupported.

Let’s try to create

CREATE TABLE dbo.Products (     ProductID INT PRIMARY KEY,     ProductName VARCHAR(50) );  INSERT INTO dbo.Products VALUES (1,'Laptop'),(2,'Mouse');  CREATE SYNONYM dbo.ProductSyn1 FOR dbo.Products;

Normal synonyms created successfully.

Let’s create an encrypted synonym.

CREATE SYNONYM TestSyn WITH ENCRYPTION FOR dbo.Products;

So we cannot encrypt  synonyms.