Loading
Topic
DROP IF EXISTS
1 post about DROP IF EXISTS by 1 contributor.
Know DROP IF EXISTS? Share what you know with developers who are learning it.
+ Follow DROP IF EXISTSBe the first to follow this
- Articles
- 1
- Contributors
- 1
Everything about DROP IF EXISTS
- Article · SQL Server
DROP IF EXISTS In SQL Server 2016
With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
