In our development many times it happens that we need to drop a table and as a best practice we write the following syntax as shown in below figure
Now, in SQL SERVER 2016 the same task is super easy. You can write the following syntax to drop the table object
DROP TABLE IF EXISTS TABLENAME
The best part is if suppose the object does not exist then here will be no error execution will continue.
Let me share one more example of Dropping a stored procedure.
Similar, way we can write for following data objects and with the following syntax
Procedure:- DROP PROCEDURE IF EXISTS Procedure Name
Assembly:-
DROP ASSEMBLY IF EXISTS Assembly Name
ROLENAME :-
DROP ROLE IF EXISTS ROLENAME
TRIGGER :-
DROP TRIGGER IF EXISTS Trigger Name
VIEW:-
DROP VIEW IF EXISTS View Name
RULE:-
DROP RULE IF EXISTS RULENAME\
Type:-
DROP TYPE IF EXISTS Type Name
Database:- DROP DATABASE IF EXISTS Database Name
Schema:-
DROP SCHEMA IF EXISTS Schema Name
User:-
DROP USER IF EXISTS Username
SECURITY POLICY:-
DROP SECURITY POLICY IF EXISTS Policy Name
View :-
DROP VIEW IF EXISTS View Name
FUNCTION:-
DROP FUNCTION IF EXISTS Function Name
SEQUENCE:-
DROP SEQUENCE IF EXISTS Sequence Name
Synonym:-
DROP SYNONYM IF EXISTS Synonym Name
I like this feature I am sure you will also like this.
Please, do share your feedback for blog post.
Enjoy !!
