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
Komentáře k této Příručce