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

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
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.