[dbo].[mdb_checkpoint]

(local) > mdb > Tables > dbo.mdb_checkpoint

Properties
Columns
Indexes
Permissions
SQL Script
Uses
Used By

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

Columns

Name	Data Type	Max Length (Bytes)
checkpointid	int	4
firstjournal	int	4
lastjournal	int	4
firstdump	int	4
lastdump	int	4
datetime	datetime	8

Indexes

	Name	Columns	Unique
	$mdb_c_u00004af000000000	checkpointid

Permissions

Type	Action	Owning Principal
Grant	Select	ca_itrm_group
Grant	Select	ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[mdb_checkpoint]
(
[checkpointid] [int] NOT NULL,
[firstjournal] [int] NULL,
[lastjournal] [int] NULL,
[firstdump] [int] NULL,
[lastdump] [int] NULL,
[datetime] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mdb_checkpoint] ADD CONSTRAINT [$mdb_c_u00004af000000000] PRIMARY KEY CLUSTERED ([checkpointid]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[mdb_checkpoint] TO [ca_itrm_group]
GRANT SELECT ON [dbo].[mdb_checkpoint] TO [ca_itrm_group_ams]
GO

Uses

Used By