17 July, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to create a schema in a Microsoft SQL Server database only when it does not exist, use:

declare @SchemaName nvarchar(128)
set @SchemaName = 'Staging'

if not exists(select top 1 1 from information_schema.schemata where schema_name = @SchemaName)
begin
    exec('create schema ' + @SchemaName)
end
go
Tags:
Category: Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts