if not exists(select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'auditlog' AND TABLE_NAME = 'Users') create table auditlog.Users( USERID int not null identity(-1000, -1), USERNAME nvarchar(1000) not null, CREATED datetime not null default (getdate()), constraint PK_auditlog_Users primary key clustered (USERID desc), constraint UK_auditlog_Users unique (USERNAME) )