CREATE DATABASE demo1
GO

USE demo1
GO

CREATE LOGIN alogin1 WITH password = 'password1',
DEFAULT_DATABASE = demo1
GO

-- default named schema
CREATE USER auser1 FOR LOGIN alogin1
WITH DEFAULT_SCHEMA = aschema1
GO

CREATE SCHEMA aschema1 AUTHORIZATION auser1
GO

GRANT CREATE TABLE TO auser1
GO

SETUSER 'auser1'
GO

-- this works and creates aschema1.table1
CREATE TABLE table1 (theid INTEGER)
GO