[dbo].[alias]

[dbo].[alias]

Properties
Columns
Indexes
Permissions
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	12:30:41 PM Sunday, December 05, 2010
Last Modified	12:30:41 PM Sunday, December 05, 2010

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