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