beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 5

background image

Materialized Views Tab...................................................................................................................64
Materialized View Groups Tab........................................................................................................64
Views Tab.........................................................................................................................................65
Procedures Tab................................................................................................................................65
Synonyms Tab..................................................................................................................................65
DDL Tab...........................................................................................................................................65
Privileges Tab...................................................................................................................................66
Schema Size.....................................................................................................................................66

Display Tables and Their Properties.....................................................................................................66

Columns Tab....................................................................................................................................67
Primary Key Tab..............................................................................................................................68
Hash Key Tab...................................................................................................................................68
Unique Constraints Tab...................................................................................................................68
Foreign Keys Tab.............................................................................................................................69
Attributes Tab..................................................................................................................................69
Partitions Tab...................................................................................................................................69
Usage Tab.........................................................................................................................................69
DDL Tab...........................................................................................................................................70
Statistics Tab....................................................................................................................................70
Privileges Tab...................................................................................................................................70
Tables Summary..............................................................................................................................71

Display Table Indexes and Their Properties.........................................................................................71

Columns Tab....................................................................................................................................72
Attributes Tab..................................................................................................................................72
DDL Tab...........................................................................................................................................73
Partitions Tab...................................................................................................................................73
Table Indexes Summary..................................................................................................................73

Display Views and Their Properties.....................................................................................................74

Columns Tab....................................................................................................................................74
Usage Tab.........................................................................................................................................75
DDL Tab...........................................................................................................................................75
Privileges Tab...................................................................................................................................75

Display Materialized Views and Their Properties................................................................................76

Attributes Tab..................................................................................................................................77
Partitions Tab...................................................................................................................................78
Usage Tab.........................................................................................................................................79
DDL Tab...........................................................................................................................................79
Privileges Tab...................................................................................................................................79
Materialized Views Summary.........................................................................................................80

Display Materialized View Indexes and Their Properties....................................................................80

Columns Tab....................................................................................................................................81
Attributes Tab..................................................................................................................................81
DDL Tab...........................................................................................................................................82
Partitions Tab...................................................................................................................................82
Materialized View Indexes Summary.............................................................................................82

Display Materialized View Groups and Their Properties....................................................................83

Attributes Tab..................................................................................................................................84
Members Tab...................................................................................................................................84
DDL Tab...........................................................................................................................................84

Display Procedures and Their Properties.............................................................................................84

Attributes Tab..................................................................................................................................85
Parameters Tab.................................................................................................................................86
Usage Tab.........................................................................................................................................86
Privileges Tab...................................................................................................................................86

Display Synonyms and Their Properties..............................................................................................87

Table of Contents

5