Supprimer tous les synonymes d’une base SQLServer
declare @n char(1) set @n = char(10) declare @stmt nvarchar(max) select @stmt = isnull( @stmt + @n, '' ) + 'drop synonym [' + SCHEMA_NAME(schema_id) + '].[' + name + ']' from sys.synonyms exec sp_executesql @stmt