[dbo].[templateworkloadjob1]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:33 AM Wednesday, March 07, 2007
Last Modified	11:09:45 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_templateworkloadjob1: templateid\templatejobid$	templateid	int	4
	instancename	varchar(100)	100
	jobtype	varchar(50)	50
	regionid	int	4
	boxjobid	int	4
	jobleft	int	4
	jobright	int	4
	jobtop	int	4
	jobbottom	int	4
$Indexes baseidx_templateworkloadjob1: templateid\templatejobid$	templatejobid	int	4
	jobname	varchar(100)	100
	applicationid	varchar(50)	50
	abendaction	varchar(100)	100
	anycpu	varchar(50)	50
	autosel	varchar(50)	50
	autostart	varchar(50)	50
	averagetime	varchar(50)	50
	backlog	varchar(50)	50
	calendar	varchar(50)	50
	createdate	varchar(50)	50
	createtime	varchar(50)	50
	createuser	varchar(100)	100
	adjustment	varchar(50)	50
	critcal	varchar(50)	50
	crithact	varchar(50)	50
	critnwact	varchar(50)	50
	critkeys	varchar(1)	1
	cycfreq	varchar(50)	50
	cyccount	varchar(50)	50
	cyclic	varchar(50)	50
	wk_condition	varchar(1)	1

Name	Columns	Unique
baseidx_templateworkloadjob1	templateid, templatejobid

SQL Script

CREATE TABLE [dbo].[templateworkloadjob1]
(
[templateid] [int] NOT NULL,
[instancename] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobtype] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[regionid] [int] NULL,
[boxjobid] [int] NULL,
[jobleft] [int] NULL,
[jobright] [int] NULL,
[jobtop] [int] NULL,
[jobbottom] [int] NULL,
[templatejobid] [int] NULL,
[jobname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[applicationid] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[abendaction] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[anycpu] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[autosel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[autostart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[averagetime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[backlog] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[calendar] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createdate] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createtime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createuser] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[adjustment] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critcal] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[crithact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critnwact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[critkeys] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cycfreq] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cyccount] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cyclic] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[wk_condition] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_templateworkloadjob1] ON [dbo].[templateworkloadjob1] ([templateid], [templatejobid]) ON [PRIMARY]
GO