Comments on: DROP TABLE IF EXIST in MS SQL

Comments on: DROP TABLE IF EXIST in MS SQL/2011/05/03/drop-table-if-exist-in-ms-sql/Sharing my work and study experience with technologies.Tue, 03 Nov 2015 12:52:23 +0000hourly1http://wordpress.com/By: Jovan Popovic/2011/05/03/drop-table-if-exist-in-ms-sql/#comment-252Tue, 03 Nov 2015 12:52:23 +0000/?p=21#comment-252In SQL Server 2016 you can use DROP IF EXISTS:
DROP TABLE IF EXISTS Table_Name

See http://blogs.msdn.com/b/sqlserverstorageengine/archive/2015/11/03/drop-if-exists-new-thing-in-sql-server-2016.aspx

]]>By: Ronnie Zhanje/2011/05/03/drop-table-if-exist-in-ms-sql/#comment-197Fri, 14 Nov 2014 08:00:15 +0000/?p=21#comment-197For sql server 2012 you can use the following.

IF OBJECT_ID(‘Table_Name, ‘U’) IS NOT NULL
DROP TABLE Table_Name

]]>