Tables [dbo].[e2e_wrm_reportcolumn]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count133
Created11:07:13 AM Wednesday, March 07, 2007
Last Modified11:07:13 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
columnidint4
No
thresholdreportidint4
Yes
thresholdcolumnidint4
Yes
columnnamevarchar(255)255
No
isvisiblesmallint2
Yes
sortbysmallint2
Yes
formulavarchar(255)255
Yes
isdistincttinyint1
Yes
isgroupsmallint2
Yes
titlevarchar(255)255
Yes
presentationsmallint2
Yes
inworkspacetinyint1
Yes
unitidint4
Yes
reportidint4
No
Permissions
TypeActionOwning Principal
GrantDeleteapmadmin
GrantInsertapmadmin
GrantSelectapmadmin
GrantUpdateapmadmin
SQL Script
CREATE TABLE [dbo].[e2e_wrm_reportcolumn]
(
[columnid] [int] NOT NULL,
[thresholdreportid] [int] NULL,
[thresholdcolumnid] [int] NULL,
[columnname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[isvisible] [smallint] NULL,
[sortby] [smallint] NULL,
[formula] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[isdistinct] [tinyint] NULL,
[isgroup] [smallint] NULL,
[title] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[presentation] [smallint] NULL,
[inworkspace] [tinyint] NULL,
[unitid] [int] NULL,
[reportid] [int] NOT NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_wrm_reportcolumn] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_wrm_reportcolumn] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_wrm_reportcolumn] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_wrm_reportcolumn] TO [apmadmin]
GO
Uses
Used By