[dbo].[usm_lastid]

[dbo].[usm_lastid]

Properties
Columns
Indexes
Permissions
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	117
Created	11:07:43 AM Wednesday, March 07, 2007
Last Modified	11:09:15 AM Wednesday, March 07, 2007

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	name	varchar(64)	64
	id	int	4

Indexes

	Name	Columns	Unique
	XPKusm_lastid	name

Permissions

Type	Action	Owning Principal
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Select	usmgroup
Grant	Update	usmgroup

SQL Script

CREATE TABLE [dbo].[usm_lastid]
(
[name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_lastid] ADD CONSTRAINT [XPKusm_lastid] PRIMARY KEY CLUSTERED ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_lastid] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_lastid] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_lastid] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_lastid] TO [usmgroup]
GO

Uses

Used By

[dbo].[usm_next_sequence_value]