Drop If Exists Feature In Sql Server 2016

If you need to delete a table , then you are used to writing code like this. If the table exists it will drop.We all have been writing code like this for years.


In SQL server you can simply drop a table like this.You can use this syntax for droping indexes,databases,roles,defaults,schemas and so on
DROP TABLE IF EXISTS  dbo.Customer