Drop table if exists. The prior method of dropping a table is as follows. If we are using SQL Server 2015 or earlier than we need to execute the following bunch of code. If(OBJECT_ID('dbo.temp') Is ...

Multiple times users have run into a scenario where they had accidentally deleted the table files from storage but they cannot drop the table from catalog. a) User cannot use "Drop Table SQL", as even ...