15.00 - Rules for Adding and Dropping Ranges in a Character Partitioning Expression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Rules for Adding and Dropping Ranges in a Character Partitioning Expression

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 aborts the request and 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 aborts the request and returns an error to the requestor.