[dbo].[templatebob2]

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_templatebob2: templateid\templatejobid$	templateid	int	4
$Indexes baseidx_templatebob2: templateid\templatejobid$	templatejobid	int	4
	bagname	varchar(100)	100
	job_mode	varchar(100)	100
	application	varchar(100)	100
	as_group	varchar(100)	100
	max_concur_runs	varchar(50)	50
	save_cycles	varchar(50)	50
	restart_wait	varchar(50)	50
	run_as_ptid	varchar(100)	100
	not_after_start_time	varchar(50)	50
	pre_load_mins	varchar(50)	50
	alarm_start_late	varchar(50)	50
	avg_duration	varchar(50)	50
	operator_ok	varchar(50)	50
	app_status_var	varchar(100)	100
	sched_name	varchar(100)	100
	job_variable	varchar(100)	100
	kill_signal	varchar(1)	1
	target_mode	varchar(100)	100

Name	Columns	Unique
baseidx_templatebob2	templateid, templatejobid

SQL Script

CREATE TABLE [dbo].[templatebob2]
(
[templateid] [int] NOT NULL,
[templatejobid] [int] NOT NULL,
[bagname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[job_mode] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[application] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_group] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[max_concur_runs] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[save_cycles] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[restart_wait] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[run_as_ptid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[not_after_start_time] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pre_load_mins] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[alarm_start_late] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[avg_duration] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[operator_ok] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[app_status_var] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sched_name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[job_variable] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[kill_signal] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[target_mode] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_templatebob2] ON [dbo].[templatebob2] ([templateid], [templatejobid]) ON [PRIMARY]
GO