Uncategorized

Drop all synonyms in database

Transact-SQL DECLARE @Stmt NVARCHAR(MAX) SET @Stmt = '' SELECT @Stmt = @Stmt + 'DROP SYNONYM [' + s.name + '].[' + v.name + '];' FROM sys.synonyms v INNER JOIN sys.schemas s ON s.schema_id = v.schema_id EXECUTE (@Stmt) GO SELECT * FROM sys.synonyms GO 12345678910111213 DECLARE @Stmt NVARCHAR(MAX) SET @Stmt = '' SELECT  @Stmt = @Stmt + 'DROP SYNONYM [' + s.name + '].[' + v.name + '];' FROM sys.synonyms v INNER JOIN sys.schemas s ON s.schema_id = v.schema_id EXECUTE (@Stmt)GO SELECT * FROM sys.synonymsGO