Post image

Testing for Object Existence: DROP … IF EXISTS

For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped and recreated, or modified as needed. This is especially common in the case of temp tables or table variables. If the object already exists when our script runs, the script
-> Continue reading Testing for Object Existence: DROP … IF EXISTS