[dbo].[mdb_schema_information]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	16231
Created	10:23:54 AM Sunday, December 05, 2010
Last Modified	10:23:54 AM Sunday, December 05, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

16231

Created

10:23:54 AM Sunday, December 05, 2010

Last Modified

10:23:54 AM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__mdb_sche__193DA0B700551192: FileName\FileType$	FileName	varchar(100)	100
	FileStatus	varchar(30)	30
$Cluster Primary Key PK__mdb_sche__193DA0B700551192: FileName\FileType$	FileType	varchar(30)	30
	FileLocation	varchar(30)	30
	FileVersion	varchar(10)	10
	FileTimestamp	varchar(30)	30
	InstalledTimestamp	datetime	8
	XMLData	ntext	max
	SchemaName	varchar(100)	100

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__mdb_sche__193DA0B700551192: FileName\FileType$

FileName

varchar(100)

100

FileStatus

varchar(30)

$Cluster Primary Key PK__mdb_sche__193DA0B700551192: FileName\FileType$

FileType

varchar(30)

FileLocation

varchar(30)

FileVersion

varchar(10)

FileTimestamp

varchar(30)

InstalledTimestamp

datetime

XMLData

ntext

max

SchemaName

varchar(100)

100

	Name	Columns	Unique
$Cluster Primary Key PK__mdb_sche__193DA0B700551192: FileName\FileType$	PK__mdb_sche__193DA0B700551192	FileName, FileType

Name

Columns

Unique

$Cluster Primary Key PK__mdb_sche__193DA0B700551192: FileName\FileType$

PK__mdb_sche__193DA0B700551192

FileName, FileType

Type	Action	Owning Principal
Grant	Select	ca_itrm_group

Type

Action

Owning Principal

Grant

Select

ca_itrm_group

SQL Script

CREATE TABLE [dbo].[mdb_schema_information]
(
[FileName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileStatus] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileLocation] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileVersion] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FileTimestamp] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[InstalledTimestamp] [datetime] NOT NULL,
[XMLData] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SchemaName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[mdb_schema_information] ADD CONSTRAINT [PK__mdb_sche__193DA0B700551192] PRIMARY KEY CLUSTERED ([FileName], [FileType]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[mdb_schema_information] TO [ca_itrm_group]
GO