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 Data Management: SQL Reference.
