[dbo].[e2e_wrm_wrmactivedetail]

(local) > mdb > Tables > dbo.e2e_wrm_wrmactivedetail

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	4
Created	12:30:55 PM Sunday, December 05, 2010
Last Modified	12:30:55 PM Sunday, December 05, 2010

Columns

Name	Data Type	Max Length (Bytes)	Allow Nulls
activedetailid	int	4
name	varchar(20)	20

Permissions

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

SQL Script

CREATE TABLE [dbo].[e2e_wrm_wrmactivedetail]
(
[activedetailid] [int] NOT NULL,
[name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]

GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrmactivedetail] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_wrm_wrmactivedetail] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_wrm_wrmactivedetail] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_wrm_wrmactivedetail] TO [apmadmin]
GO

Uses