Product Documentation

SQL Operations Guide

Previous Topic

Next Topic


fc_get_partbounds(owner, table_name)

Returns the first and last active partition numbers for a partitioned table. This is useful to determine the oldest (Firstactprt) partition to purge, for example. You must be connected to the database that contains the table.

Parameters (2)


owner VARCHAR(64)

table_name VARCHAR(64)

Result Set Fields (2)


Firstactprt -- "First Active Partition number"

Lastactprt -- "Last Active Partition number"