Tables [dbo].[e2e_wrm_report]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count21
Created11:07:13 AM Wednesday, March 07, 2007
Last Modified11:09:37 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
reportidint4
No
Indexes xak1e2e_wrm_report: titletitlechar(254)254
No
tablenamevarchar(255)255
No
allcolumnstinyint1
No
isdistincttinyint1
Yes
reporttypesmallint2
No
Indexes Indexes
NameColumnsUnique
xak1e2e_wrm_reporttitle
Yes
Permissions
TypeActionOwning Principal
GrantDeleteapmadmin
GrantInsertapmadmin
GrantSelectapmadmin
GrantUpdateapmadmin
SQL Script
CREATE TABLE [dbo].[e2e_wrm_report]
(
[reportid] [int] NOT NULL,
[title] [char] (254) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tablename] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[allcolumns] [tinyint] NOT NULL,
[isdistinct] [tinyint] NULL,
[reporttype] [smallint] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xak1e2e_wrm_report] ON [dbo].[e2e_wrm_report] ([title]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_wrm_report] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_wrm_report] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_wrm_report] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_wrm_report] TO [apmadmin]
GO
Uses
Used By