-- Table: dbo.PartitionPlanView
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[PartitionPlanView] (
	[ViewName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PlanName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PartitioningColumn] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[TableNameCommonLiteral] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[TableDDLTemplate] [varchar] (7500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	CONSTRAINT [pkc_PartitionPlanItem__ViewName] 
        PRIMARY KEY  CLUSTERED 
	(
		[ViewName]
	)  ON [PRIMARY] ,
	CONSTRAINT [fk_PartitionPlanItem__PlanName__TO__PartitionPlan__PlanName] 
        FOREIGN KEY 
	(
		[PlanName]
	) REFERENCES [dbo].[PartitionPlan] (
		[PlanName]
	)
) ON [PRIMARY]
GO