[dbo].[alias]

[dbo].[alias]

Properties
Columns
Indexes
Permissions
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	11:06:58 AM Wednesday, March 07, 2007
Last Modified	11:09:30 AM Wednesday, March 07, 2007

Columns

	Name	Data Type	Max Length (Bytes)
$Indexes ialias: a_eid\eid$	eid	int	4
$Indexes ialias: a_eid\eid$	a_eid	int	4
	flags	int	4

Indexes

Name	Columns	Unique
baseidx_alias	eid
ialias	a_eid, eid

Permissions

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

SQL Script

CREATE TABLE [dbo].[alias]
(
[eid] [int] NOT NULL,
[a_eid] [int] NOT NULL,
[flags] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [ialias] ON [dbo].[alias] ([a_eid], [eid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_alias] ON [dbo].[alias] ([eid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[alias] TO [dsaadmin]
GRANT INSERT ON  [dbo].[alias] TO [dsaadmin]
GRANT DELETE ON  [dbo].[alias] TO [dsaadmin]
GRANT UPDATE ON  [dbo].[alias] TO [dsaadmin]
GO

Uses