New databases  Changed system tables

Chapter 2: System Changes in Adaptive Server Version 15.0

New system tables

Table 2-11: New system tables

Table

Description

syspartitions

syspartitions is completely changed from the pre-15.0 version of the table. All columns are new. syspartitions supports both semantic and round-robin partitioning of tables and indexes.

syspartitionkeys

Contains a row for each column in a partition key for each hash-, range-, and list-partitioned table.





Copyright © 2005. Sybase Inc. All rights reserved. Changed system tables

View this book as PDF