The SHOW PARTITION statement allows a security administrator or a DBA to display partition information (meta data) about the primary database. It returns a result set that is ordered by a particular column based on the type of statement. The columns are determined by the options specified.

The SHOW PARTITION statement uses the following syntax:

Syntax 

SHOW { ALL PARTITION | PARTITION FOR partition_name }[ FOR TABLE table_name][ FULL | PRO_NAME | TABLE | PRO_AREA_NAME ][ COLUMN SIZE size]

Examples: SHOW PARTITION statement

The following example returns the basic information about all the partitions in the database:

SHOW ALL PARTITION

The following example returns all the partition names defined in the database:

SHOW ALL PARTITION PRO_NAME;

The following example returns all the information about all partitions defined in the database:

SHOW ALL PARTITION FULL;

For more on the SHOW PARTITION statement, see OpenEdge SQL Reference.