dbo.reqfiles

Object Type	Table
Datasource	IPMA
Database	controls

Columns

Name	Datatype	Null

reqnum	char(16)	No

obsno	int	No

filename	varchar(32)	No

diskname	char(8)	No

output_file	varchar(43)	No

size	int	No

status	char(1)	Yes

Table Usage (MB)

Distribution of Table Space

Data	17.17	Data	92.17 %
Indexes	0.85	Indexes	4.58 %
Unused	0.61	Unused	3.25 %
Total	18.63	Number of Rows	139514

Dependencies

Referencing Objects

Object Name Object Type

dbo.reqfiles.reqfiles_ix_c INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.reqfiles 
(
    reqnum      char(16)    NOT NULL,
    obsno       int         NOT NULL,
    filename    varchar(32) NOT NULL,
    diskname    char(8)     NOT NULL,
    output_file varchar(43) NOT NULL,
    size        int         NOT NULL,
    status      char(1)     NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.reqfiles.reqfiles_ix_c	INDEX