[dbo].[reportdescr]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:27 AM Wednesday, March 07, 2007
Last Modified	11:09:42 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_reportdescr: rptindex\rptpart$	rptindex	smallint	2
$Indexes baseidx_reportdescr: rptindex\rptpart$	rptpart	smallint	2
	rptorder	int	4
	rpttitle	varchar(64)	64
	rptdescription	varchar(255)	255
	rptoid	varchar(255)	255
	rptaxistitle	varchar(50)	50
	rpttitle2	varchar(64)	64
	rptresources	varchar(32)	32
	rptargtype	smallint	2
	rptstrdprocname	varchar(30)	30
	rptdrillto	smallint	2
	rptsql1	varchar(255)	255
	rptsql2	varchar(255)	255
	rptcolsortorder	smallint	2
	rptallowscaling	varchar(1)	1
	rptscale	smallint	2
	rptcharttype	smallint	2
	rptchart3d	varchar(1)	1
	rptchartstacked	smallint	2
	rptcharttype2	int	4
	rptchartgrid	smallint	2
	rptchartlegendtext	varchar(64)	64
	rptallowdrilldown	varchar(1)	1
	rptnumchartseries	smallint	2
	rptrsrcseltype	varchar(4)	4
	rptserleg	varchar(255)	255
	rptcolheader	varchar(255)	255
	rptdrilltos	varchar(48)	48
	rptnumofneededoid	smallint	2

Name	Columns	Unique
baseidx_reportdescr	rptindex, rptpart

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[reportdescr]
(
[rptindex] [smallint] NOT NULL,
[rptpart] [smallint] NOT NULL,
[rptorder] [int] NOT NULL,
[rpttitle] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptdescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptoid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptaxistitle] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rpttitle2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptresources] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptargtype] [smallint] NULL,
[rptstrdprocname] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptdrillto] [smallint] NULL,
[rptsql1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptsql2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptcolsortorder] [smallint] NULL,
[rptallowscaling] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptscale] [smallint] NULL,
[rptcharttype] [smallint] NULL,
[rptchart3d] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptchartstacked] [smallint] NULL,
[rptcharttype2] [int] NULL,
[rptchartgrid] [smallint] NULL,
[rptchartlegendtext] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptallowdrilldown] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptnumchartseries] [smallint] NULL,
[rptrsrcseltype] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptserleg] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptcolheader] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptdrilltos] [varchar] (48) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rptnumofneededoid] [smallint] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_reportdescr] ON [dbo].[reportdescr] ([rptindex], [rptpart]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[reportdescr] TO [uniadmin]
GRANT INSERT ON  [dbo].[reportdescr] TO [uniadmin]
GRANT DELETE ON  [dbo].[reportdescr] TO [uniadmin]
GRANT UPDATE ON  [dbo].[reportdescr] TO [uniadmin]
GRANT SELECT ON  [dbo].[reportdescr] TO [uniuser]
GO