check if schema exists in sql server database before creating

Gary Woodfine

Freelance Full Stack Developer at threenine.co.uk
Helps businesses by improving their technical proficiencies and eliminating waste from the software development pipelines.

A unique background as business owner, marketing, software development and business development ensures that he can offer the optimum business consultancy services across a wide spectrum of business challenges.

When writing SQL scripts it’s always a good idea to write them with the thought in mind that we will have to end up re-running the script multiple times. You also need to take into account that an object may or may not exist, andwill need to either create or recreate it on some conditions. […]