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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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.