NEW T-SQL FEATURES IN SQL SERVER 2016-I

In this post we shall check out the new features Microsoft introduced in SQL Server 2016.

This is the new addition in T-SQL where you can drop the object using DROP IF EXISTS command. Also note that even if the object does not exists, the command will not fail and execution will continue. As of the now following objects can be dropped using DROP IF EXISTS command.

Sample example for DROP DATABASE IF EXISTS

--

CREATE DATABASE testpawan
GO

--

Output

--

/*------------------------
CREATE DATABASE testpawan
GO

------------------------*/
                                    
--

--

DROP DATABASE IF EXISTS testpawan
GO

--

Output

--

/*------------------------
DROP DATABASE IF EXISTS testpawan
GO
------------------------*/
                                    
--

Refer for more details –

Enjoy !!! Keep Learning

Pawan Khowal 

Http://MSBISkills.com