CREATE SCHEMA my_schema; CREATE SCHEMA my_schema AUTHORIZATION my_owner;
CREATE SCHEMA my_schema;
IF (SCHEMA_ID('acme') IS NULL) BEGIN EXEC ('CREATE SCHEMA [acme] AUTHORIZATION [dbo]') END