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 ...
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions SQL Server and Azure SQL Managed Instance ...
-- Drop Views, Procedures and Functions, checking for dependencies and dropping dependencies first SELECT @ObjName = (SELECT TOP 1 '[' + s.name + '].[' + o.name + ']' FROM sys.objects o INNER JOIN sys ...