Using a List Partition

Create a new partition or change an existing partition according to whether one value in the row matches one of a set of predefined values unique for each partition.

Note: To create hash, list, or range partitions, you must first enable semantic partitioning.
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables and select User Tables.
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Partitions.
  4. Click the drop-down arrow and select New, or choose to an existing partition from the right pane.
  5. In the Select Partition Strategy screen, choose List.
  6. In the Select Partition Key Columns screen, use the arrow buttons to select one partition key column.
    List partitions use only one key column. The value in the partitioning key column is compared with values supplied in the partition specification window to determine the partition to which each row belongs.
  7. In the Partition Specification screen, specify the name of the partition, specify a list of discrete values, and where the partition will reside.
  8. (Optional) Click Summary to review your selected options.