[dbo].[mdb]

Property	Value
Row Count	1
Created	11:07:22 AM Wednesday, March 07, 2007
Last Modified	9:07:32 PM Friday, December 05, 2008

Property

Value

Row Count

Created

11:07:22 AM Wednesday, March 07, 2007

Last Modified

9:07:32 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key $mdb___u00004aed00000000: mdbmajorversion\mdbminorversion$	mdbmajorversion	int	4
$Cluster Primary Key $mdb___u00004aed00000000: mdbmajorversion\mdbminorversion$	mdbminorversion	int	4
	buildnumber	int	4
	releasedate	datetime	8
	installdate	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key $mdb___u00004aed00000000: mdbmajorversion\mdbminorversion$

mdbmajorversion

int

$Cluster Primary Key $mdb___u00004aed00000000: mdbmajorversion\mdbminorversion$

mdbminorversion

int

buildnumber

int

releasedate

datetime

installdate

datetime

	Name	Columns	Unique
$Cluster Primary Key $mdb___u00004aed00000000: mdbmajorversion\mdbminorversion$	$mdb___u00004aed00000000	mdbmajorversion, mdbminorversion

Name

Columns

Unique

$Cluster Primary Key $mdb___u00004aed00000000: mdbmajorversion\mdbminorversion$

$mdb___u00004aed00000000

mdbmajorversion, mdbminorversion

Type	Action	Owning Principal
Grant	Select	public
Grant	Select	ca_itrm_group
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams

Type

Action

Owning Principal

Grant

Select

public

Grant

Select

ca_itrm_group

Grant

Select

upmuser_group

Grant

Select

ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[mdb]
(
[mdbmajorversion] [int] NOT NULL,
[mdbminorversion] [int] NOT NULL,
[buildnumber] [int] NOT NULL,
[releasedate] [datetime] NOT NULL,
[installdate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mdb] ADD CONSTRAINT [$mdb___u00004aed00000000] PRIMARY KEY CLUSTERED ([mdbmajorversion], [mdbminorversion]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[mdb] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[mdb] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[mdb] TO [public]
GRANT SELECT ON  [dbo].[mdb] TO [upmuser_group]
GO