select * from sys.synonyms--rebuilding the command:select 'CREATE SYNONYM ' + quotename(SCHEMA_NAME(schema_id)) +'.' + quotename(name) --ie MyView + ' FOR ' + base_object_name --ie [SandBox].[dbo].[VW_FIXEDWIDTH]FROM sys.synonyms --Results:/*CREATE SYNONYM [dbo].[MyView] FOR [SandBox].[dbo].[VW_FIXEDWIDTH]*/