16.20 - Rules for Adding and Dropping Ranges in a Character Partitioning Expression - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The following rules apply to the ADD RANGE and DROP RANGE options for character partitioning expressions.

  • ALTER TABLE … DROP RANGE WHERE is only supported for partitioning expressions that are defined without character or graphic comparisons.
  • If you specify the ADD RANGE or DROP RANGE options for a non-character partitioning expression of a multilevel partitioned table, or on the special partitions of a RANGE_N character partitioning expression, and at least one of the partitioning expressions has character partitioning, then the session collation must be the same as the table collation.

    Otherwise, Teradata Database returns an error to the requestor.

  • If the table collation is MULTINATIONAL or CHARSET_COLL, the same collation or character set must be installed and its definition must be the same as was in effect when the table was created.

    Otherwise, Teradata Database returns an error to the requestor.