When using temporary/transient SYNONYMs within Stored Procedure, i.e.

ALTER PROCEDURE [dbo].[synonymTest]

AS

BEGIN

SET NOCOUNT ON;

if exists (select * from sys.synonyms where name = 'equipments')

drop synonym equipments

create synonym equipments for Material.dbo.Equipment

SELECT * FROM equipments

drop synonym equipments

END

It'll execute successfully via SQL Management Studio. However, when surfaced as a SQL Stored Procedure Service Object, properties are not surfaced. Having support for temporary/transient SYNONYMs Stored Procedure would be great.