Tables and Views Changes

SAP Sybase IQ 16.0 includes new and changed system tables and views.

New System Tables

System Table Contains
ISYSIQPARTITIONCOLUMN One row for each column of a partition described in ISYSPARTITION view in a partitioned table described in the ISYSPARTITIONSCHEME view.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITION System View for details.
ISYSLDAPSERVER Contains attributes for the LDAP server.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSLDAPSERVER.
ISYSIQRLVMERGEHISTORY

New table logging RLV merge events from the RLV store to the IQ main store. A log entry is added for each row-level versioning (RLV) enabled-table each time a merge between the RLV store and the IQ main store begins. Log entries are updated when the merge is complete.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQRLVMERGEHISTORY System View for details.
ISYSIQRVLOG

New table tracking RLV log streams.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQRVLOG System View for details.
ISYSCERTIFICATE

New table storing certificates in text PEM-format.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSCERTIFICATE System View for details.
ISYSPARTITION

One row for each range subpartition of a hash-range partitioned table. Because Hash partitions are logical rather than physical objects, ISSYPARTITION will not contain any rows for hash partitions of hash partitioned table or hash-range partitioned table.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITION System View for details.
ISYSPARTITIONKEY*

One row for each column of a partition key.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITIONKEY System View for details.
ISYSPARTITIONSCHEME

One row for each hash partitioned table and each hash-range partitioned table. The hash function and the number of hash partitions per table is fixed for the database and is not stored as part of this table.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITIONSCHEME System View for details.
ISYSROLEGRANTEXT New table containing syntax extensions pertaining to the SET USER and CHANGE PASSWORD system privileges.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSROLEGRANTEXT.
ISYSROLEGRANT New table containing one row for each grant of a system or user-defined role.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSROLEGRANT.
ISYSSUBPARTITIONKEY*

One row for each column of a subpartition key.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSSUBPARTITIONKEY System View for details.
Note: *ISYSPARTITIONKEY and ISYSSUBPARTITIONKEY share identical schemas.

Changed System Tables

System Table Description of Change
ISYSIQDBSPACE

New column is_rlv_store indicating if the dbspace is a RLV store dbspace.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQDBSPACE System View for details.
ISYSIQIDX
Removed columns:
  • link_table_id
  • link_column_id
ISYSIQTAB

New column is_rlv indicating if RLV storage is enabled on this table.

Removed column join_id.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQTAB System View for details.
ISYSIQTABCOL
Removed columns:
  • link_table_id
  • link_column_id
  • has_original
  • original_not_null
  • original_unique

Added column is_nbit
ISYSTABLEPERM Column loadauth and truncateauth added to indicate current grant status of the object privileges.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSTABLEPERM.
ISYSUSER Columns for user_dn and user_dn_cached_at added for LDAP user authentication. Column user_type added to identify user type for RBAC. Column dual_password added for the first and second parts of the dual password for a user.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSUSER.
Parent topic: Behavior Changes
Related concepts
Backward Compatibility: Changes to Default Behavior
Backward Compatibility: Migration Considerations
Connection Changes
Database Option Changes
JRE and Java Runtime Environment Variable Changes
Logical Server Policy Option Changes
Login Policy Option Changes
ODBC Driver Changes
Query Plan Changes
SQL Function Changes
SQL Statement Changes
Stored Procedure Changes
Utility Option Changes
Discontinued Tables and Views
Deprecated System Tables and Views