dbo.pmrfile

Object Type	Table
Datasource	IPMA
Database	controls

Columns

Name	Datatype	Null

reqnum	char(16)	No

obsno	int	No

filename	char(15)	No

size	int	No

status	char(1)	No

Table Usage (MB)

Distribution of Table Space

Data	127.37	Data	43.18 %
Indexes	166.21	Indexes	56.35 %
Unused	1.39	Unused	0.47 %
Total	294.97	Number of Rows	2673698

Dependencies

Referencing Objects

Object Name Object Type

dbo.reqsum VIEW

dbo.pmrfile.pmrfile_ux INDEX

dbo.pmrfile.pmrfile_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pmrfile 
(
    reqnum   char(16) NOT NULL,
    obsno    int      NOT NULL,
    filename char(15) NOT NULL,
    size     int      NOT NULL,
    status   char(1)  NOT NULL
)
LOCK DATAPAGES
WITH EXP_ROW_SIZE=1
go

Object Name	Object Type
dbo.reqsum	VIEW
dbo.pmrfile.pmrfile_ux	INDEX
dbo.pmrfile.pmrfile_ix	INDEX