dbo.pmreq

Object Type	Table
Datasource	IPMA
Database	controls

Columns

Name	Datatype	Null

reqnum	char(16)	No

username	char(8)	No

medium	char(1)	No

compress	char(2)	No

totsize	float	No

status	varchar(24)	No

start_tim	smalldatetime	No

exp_end_t	smalldatetime	Yes

outdir	varchar(40)	Yes

Table Usage (MB)

Distribution of Table Space

Data	2.47	Data	68.08 %
Indexes	0.93	Indexes	25.63 %
Unused	0.23	Unused	6.29 %
Total	3.63	Number of Rows	26383

Dependencies

Referencing Objects

Object Name Object Type

dbo.reqsum VIEW

dbo.pmreq.pmreq_ix_c INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pmreq 
(
    reqnum    char(16)      NOT NULL,
    username  char(8)       NOT NULL,
    medium    char(1)       NOT NULL,
    compress  char(2)       NOT NULL,
    totsize   float         NOT NULL,
    status    varchar(24)   NOT NULL,
    start_tim smalldatetime NOT NULL,
    exp_end_t smalldatetime NULL,
    outdir    varchar(40)   NULL
)
LOCK DATAPAGES
go

Object Name	Object Type
dbo.reqsum	VIEW
dbo.pmreq.pmreq_ix_c	INDEX