Rules of Use for Partitioning with Expressions | ALTER TABLE | Teradata Vantage - 17.10 - Rules for Adding and Dropping Ranges in a Character Partitioning Expression - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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, the 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, the database returns an error to the requestor.