Reference: Building Blocks, Tables, and Procedures Documentation Changes

Read about updates to Reference: Building Blocks, Tables, and Procedures.

These changes affect System Procedures.

sp_iqrebuildindex Procedure
Topic Section Correction
Alphabetical List of System Stored Procedures Description
Note: A third-party reference document describes an unsupported sp_iqrebuildindex syntax. Please note that specifying the table name in the index clause results in an error:
sp_iqrebuildindex tb1, 'column tb1.c1'
sp_iqrowdensity Procedure
Topic Section Description

Alphabetical List of System Stored Procedures

Description

The sp_iqrowdensity IndexType column always returns the maximum number of bits required to encode the column.

Unlike the FP(1), FP(2), FP(3) dictionary compression in previous releases, which uses the same number of bits for each page, NBit encodes each page dynamically. sp_iqrowdensity always returns the largest number of bits used among all of the pages

.
These changes affect Differences from Other SQL Dialects.
Altering Tables
Topic Section Correction

Altering Tables

ALTER TABLE  has been extended.

In addition to changes for entity and referential integrity, the following types of alterations are allowed: 

DELETE column
RENAME new-table-name
RENAME old-column TO new-column

You can use  MODIFY  to change the maximum length of a character column, as well as converting from one data type to another.

ALTER TABLE  has been extended.

In addition to changes for entity and referential integrity, the following types of alterations are allowed: 

DELETE column
RENAME new-table-name
RENAME old-column TO new-column

These changes affect Physical Limitations.

Physical Limitations
Item Limitation Correction

Number of indexes

 2^32 (~4,000,000) per table 2^32 (~4,000,000,000) per table
Parent topic: Documentation Changes