[dbo].[entry]

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:38 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

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

Last Modified

11:09:38 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_entry: eid\aid\vid$	eid	int	4
$Indexes baseidx_entry: eid\aid\vid$	aid	smallint	2
$Indexes baseidx_entry: eid\aid\vid$	vid	smallint	2
	raw	varchar(115)	115
	flags	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes baseidx_entry: eid\aid\vid$

eid

int

$Indexes baseidx_entry: eid\aid\vid$

aid

smallint

$Indexes baseidx_entry: eid\aid\vid$

vid

smallint

raw

varchar(115)

115

flags

int

Name	Columns	Unique
baseidx_entry	eid, aid, vid

Name

Columns

Unique

baseidx_entry

eid, aid, vid

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

Type

Action

Owning Principal

Grant

Delete

dsaadmin

Grant

Insert

dsaadmin

Grant

Select

dsaadmin

Grant

Update

dsaadmin

SQL Script

CREATE TABLE [dbo].[entry]
(
[eid] [int] NOT NULL,
[aid] [smallint] NOT NULL,
[vid] [smallint] NOT NULL,
[raw] [varchar] (115) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[flags] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_entry] ON [dbo].[entry] ([eid], [aid], [vid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[entry] TO [dsaadmin]
GRANT INSERT ON  [dbo].[entry] TO [dsaadmin]
GRANT DELETE ON  [dbo].[entry] TO [dsaadmin]
GRANT UPDATE ON  [dbo].[entry] TO [dsaadmin]
GO