beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 4

background image

Primary Key Tab..............................................................................................................................27
Hash Key Tab...................................................................................................................................27
Unique ConstraintsTab....................................................................................................................27
Foreign Keys Tab.............................................................................................................................28
Attributes Tab..................................................................................................................................28
Partitions Tab...................................................................................................................................28
Usage Tab.........................................................................................................................................29
DDL Tab...........................................................................................................................................29
Statistics Tab....................................................................................................................................29
Privileges Tab...................................................................................................................................29
Displaying Tables Summary............................................................................................................30

Displaying Table Indexes and Their Properties....................................................................................31

Columns Tab....................................................................................................................................31
Attributes Tab..................................................................................................................................32
DDL Tab...........................................................................................................................................32
Partitions Tab...................................................................................................................................32
Displaying Table Indexes Summary................................................................................................32

Displaying Views and Their Properties................................................................................................34

Columns Tab....................................................................................................................................34
Usage Tab.........................................................................................................................................35
DDL Tab...........................................................................................................................................35
Privileges Tab...................................................................................................................................35

Displaying Materialized Views and Their Properties..........................................................................37

Attributes Tab..................................................................................................................................37
Partitions Tab...................................................................................................................................38
Usage Tab.........................................................................................................................................39
DDL Tab...........................................................................................................................................39
Privileges Tab...................................................................................................................................39
Displaying Materialized Views Summary......................................................................................40

Displaying Materialized View Indexes and Their Properties..............................................................41

Columns Tab....................................................................................................................................41
Attributes Tab..................................................................................................................................42
DDL Tab...........................................................................................................................................42
Partitions Tab...................................................................................................................................42
Displaying Materialized View Indexes Summary..........................................................................43

Displaying Materialized View Groups and Their Properties...............................................................44

Attributes Tab..................................................................................................................................44
Members Tab ...................................................................................................................................45
DDL Tab...........................................................................................................................................45

Displaying Procedures and Their Properties........................................................................................46

Attributes Tab..................................................................................................................................46
Parameters Tab.................................................................................................................................47
DDL Tab...........................................................................................................................................47
Privileges Tab...................................................................................................................................47

Displaying Synonyms and Their Properties.........................................................................................49

Attributes Tab..................................................................................................................................49
Usage Tab.........................................................................................................................................50
DDL Tab...........................................................................................................................................50

Displaying Triggers and Their Properties............................................................................................51

Attributes Tab..................................................................................................................................51
Usage Tab.........................................................................................................................................52
DDL Tab...........................................................................................................................................52

Displaying Schema DDL and Their Properties....................................................................................53

DDL Tab...........................................................................................................................................53
Show DDL .......................................................................................................................................53

4

Table of Contents