USE [SampleDB]

IF ((SELECT COUNT(*) FROM sys.schemas WHERE name = N'sampleSchema') = 0)

BEGIN

exec('CREATE SCHEMA [sampleSchema] AUTHORIZATION [dbo]')

PRINT 'Schema Exists'

END

GO

- Serves our purpose