[dbo].[engine

[dbo].[engine_config]

(local) > mdb > Tables > dbo.engine_config

Properties
Columns
Indexes
SQL Script
Uses

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

Columns

Name	Data Type	Max Length (Bytes)
name	varchar(32)	32
sequence	tinyint	1
job_name	varchar(32)	32
engine_type	varchar(8)	8
xml_config	varchar(1950)	1950

Indexes

Name	Columns	Unique
$engin_u0000355700000000	name

SQL Script

CREATE TABLE [dbo].[engine_config]
(
[name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[sequence] [tinyint] NULL,
[job_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[engine_type] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[xml_config] [varchar] (1950) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$engin_u0000355700000000] ON [dbo].[engine_config] ([name]) ON [PRIMARY]
GO

Uses