SQL Server 在创建数据库的时候默认的schema是dbo. 可是要在创建数据库时利用不同的schema创建表,这个时候就应该先创建shema,然后再在这个schema下创建表. 具体的示例如下:
if exists (select * from sys.schemas where name = 'BillingPlan')
drop schema "BillingPlan"
GO
CREATE SCHEMA BillingPlan AUTHORIZATION db_owner
/*Create table BillingPlan.ResourceAccess*/
CREATE TABLE "ResourceAccess"
(
"ServiceResourceId" uniqueidentifier NOT NULL,
"ParentServiceResourceId" uniqueidentifier NOT NULL,
CONSTRAINT "PK_ResourceAccess" PRIMARY KEY CLUSTERED
(
"ServiceResourceId"
)
)
/*Create table BillingPlan.Type'*/
CREATE TABLE "Type"
(
BillingPlanTypeId Smallint NOT NULL,
BillingPlanTypeName Varchar(20) NULL,
ResourceTypeId smallint NULL,