Tables [dbo].[e2e_apm_reportcolumn]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count435
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
Yes
reportidint4
Yes
columnnamevarchar(255)255
Yes
isvisiblesmallint2
Yes
sortbysmallint2
Yes
formulavarchar(255)255
Yes
isdistincttinyint1
Yes
isgroupsmallint2
Yes
titlevarchar(255)255
Yes
presentationsmallint2
Yes
unitidint4
Yes
inworkspacetinyint1
Yes
thresholdreportidint4
Yes
thresholdcolumnidint4
Yes
Permissions
TypeActionOwning Principal
GrantDeleteapmadmin
GrantInsertapmadmin
GrantSelectapmadmin
GrantUpdateapmadmin
SQL Script
CREATE TABLE [dbo].[e2e_apm_reportcolumn]
(
[columnid] [int] NULL,
[reportid] [int] NULL,
[columnname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS 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,
[unitid] [int] NULL,
[inworkspace] [tinyint] NULL,
[thresholdreportid] [int] NULL,
[thresholdcolumnid] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_apm_reportcolumn] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_apm_reportcolumn] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_apm_reportcolumn] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_apm_reportcolumn] TO [apmadmin]
GO
Uses