[dbo].[templateworkloadjob2]

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_templateworkloadjob2: templateid\templatejobid$	templateid	int	4
$Indexes baseidx_templateworkloadjob2: templateid\templatejobid$	templatejobid	int	4
	earlytime	varchar(50)	50
	effectivedate	varchar(50)	50
	expiresdate	varchar(50)	50
	failcondl	varchar(50)	50
	failcondh	varchar(50)	50
	history	varchar(50)	50
	hold	varchar(50)	50
	jobnumber	varchar(5)	5
	interruptible	varchar(50)	50
	boxname	varchar(100)	100
	maxtime	varchar(50)	50
	mustcomptime	varchar(50)	50
	muststarttime	varchar(50)	50
	subuserid	varchar(50)	50
	subdomain	varchar(50)	50
	subpass	varchar(100)	100
	subfile	varchar(1)	1
	priority	varchar(50)	50
	settype	varchar(50)	50
	skip	varchar(50)	50
	station	varchar(50)	50
	updatedate	varchar(50)	50
	updatetime	varchar(50)	50
	updateuser	varchar(50)	50
	userenv	varchar(50)	50
	description	varchar(1)	1
	type	varchar(50)	50

Name	Columns	Unique
baseidx_templateworkloadjob2	templateid, templatejobid

SQL Script

CREATE TABLE [dbo].[templateworkloadjob2]
(
[templateid] [int] NOT NULL,
[templatejobid] [int] NOT NULL,
[earlytime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[effectivedate] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[expiresdate] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[failcondl] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[failcondh] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[history] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hold] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobnumber] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[interruptible] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[boxname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[maxtime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mustcomptime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[muststarttime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subuserid] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subdomain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subpass] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subfile] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[settype] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[skip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[station] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatedate] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatetime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updateuser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[userenv] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_templateworkloadjob2] ON [dbo].[templateworkloadjob2] ([templateid], [templatejobid]) ON [PRIMARY]
GO