[dbo].[deletedjobs]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	12:30:53 PM Sunday, December 05, 2010
Last Modified	12:30:53 PM Sunday, December 05, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

12:30:53 PM Sunday, December 05, 2010

Last Modified

12:30:53 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_deletedjobs: instancename\jobname$	instancename	varchar(64)	64
$Indexes baseidx_deletedjobs: instancename\jobname$	jobname	varchar(139)	139
	triggertype	varchar(9)	9

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes baseidx_deletedjobs: instancename\jobname$

instancename

varchar(64)

$Indexes baseidx_deletedjobs: instancename\jobname$

jobname

varchar(139)

139

triggertype

varchar(9)

Name	Columns	Unique
baseidx_deletedjobs	instancename, jobname
deletedjobs_idx_01	jobname

Name

Columns

Unique

baseidx_deletedjobs

instancename, jobname

deletedjobs_idx_01

jobname

SQL Script

CREATE TABLE [dbo].[deletedjobs]
(
[instancename] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jobname] [varchar] (139) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[triggertype] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_deletedjobs] ON [dbo].[deletedjobs] ([instancename], [jobname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [deletedjobs_idx_01] ON [dbo].[deletedjobs] ([jobname]) ON [PRIMARY]
GO