The syspartitions Table

The syspartitions table lists each table and index partition and the segment where the partition is stored.

syspartitions maintains key storage management information such as the first page of a data or index page chain, the last page of a heap, the root page of an index partition, and so on.

Use create table, create index and alter table to create new rows in syspartitions.