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 ...
Deletes tables, views, or indexes. Restriction: You cannot use DROP TABLE or DROP INDEX on a table accessed via an engine that does not support UPDATE processing. If you drop a table that is ...