check if schema exists in sql server database before creating





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.

In my particular case I need to check if schema exists in SQL server database and create a new Schema within a database. i.e. Archive . I tried a simple approach similar too.

How to check if schema exists on sql server

It turns out that a CREATE SCHEMA needs to be a first command in a batch and cannot be wrapped in an if statement.  So a little work around is needed.

In my particular case that worked a treat. I was able to develop my scripts that I needed and check if my specific schemas were available



What doesn’t work

When I tried running the script MS SQL simply responded




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.

Affiliate Disclaimer

Disclosure: Please note that some of the links included in the blog posts are affiliate links, which means I will earn a commission if you decide to make a purchase.

I only include affiliate links to products, services and companies that I have personal experience and have actually used. I only recommend them because they are helpful and useful, not because of the small commissions I make if you decide to buy something.

Please do not spend any money on these products unless you feel they are relevant, suitable and will help you achieve your goals.

Buying anyone of these products and the commisions earned will not make me an overnite multi millionaire, but they will help to cover the hosting costs and compensate for the countless hours and effort I put in to create meaningful and valuable free content I provide to help others succeed.

You've also undoubtedly noticed that I also use various advertising networks - unless of of course you're using an Ad blocker, this is also an attempt to reduce my monthly deficit I experience in providing free relevant, valuable and on occassion insightful content for the benefit of others.

I only really make some money if people click on the ads, unless of course you consider 1c per 1000 impressions real money!

Bear in mind just how many impressions I need to make before I can cover my £20 hosting costs a month!

If you are using an adblocker and guilt stricken you can of course donate using any of the buttons below, but I won't be holding my breath.


Buy me a coffeeBuy me a coffee
π