[dbo].[templatebob]

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_templatebob: templateid\templatejobid$	templateid	int	4
$Indexes baseidx_templatebob: templateid\templatejobid$	templatejobid	int	4
	jobname	varchar(100)	100
	instancename	varchar(100)	100
	regionid	int	4
	jobowner	varchar(255)	255
	boxjobid	int	4
	jobtype	varchar(32)	32
	jobleft	int	4
	jobright	int	4
	jobtop	int	4
	jobbottom	int	4
	as_condition	varchar(1)	1
	as_dateconditions	varchar(100)	100
	as_machine	varchar(255)	255
	as_startmins	varchar(1)	1
	as_starttimes	varchar(1)	1
	as_command	varchar(1)	1
	as_description	varchar(1)	1
	as_watchfile	varchar(1)	1
	as_watchfileminsize	varchar(255)	255
	boxname	varchar(100)	100

Name	Columns	Unique
baseidx_templatebob	templateid, templatejobid

SQL Script

CREATE TABLE [dbo].[templatebob]
(
[templateid] [int] NOT NULL,
[templatejobid] [int] NOT NULL,
[jobname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[instancename] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[regionid] [int] NULL,
[jobowner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[boxjobid] [int] NULL,
[jobtype] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobleft] [int] NULL,
[jobright] [int] NULL,
[jobtop] [int] NULL,
[jobbottom] [int] NULL,
[as_condition] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_dateconditions] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_machine] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_startmins] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_starttimes] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_command] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_description] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_watchfile] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_watchfileminsize] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[boxname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_templatebob] ON [dbo].[templatebob] ([templateid], [templatejobid]) ON [PRIMARY]
GO