This article discusses the “DROP IF EXISTS” statement available in SQL Server 2016 and later versions. “IF EXITS” is the latest optional clause added in the existing DROP statement in SQL Server 2016 ...
When you rename a trigger, the trigger must be in the current database, and the new name must follow the rules for [identifiers](../databases/database-identifiers.md).
Some results have been hidden because they may be inaccessible to you
Show inaccessible results