15.00 - Maximum Number of Columns Per Table - 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)

Maximum Number of Columns Per Table

A base table can contain a maximum of 2,048 columns. No more than 32 of those columns can be defined with a LOB data type (see “Rules and Restrictions for Large Object Data Types” on page 37).

A maximum of 2,560 columns can be defined for a base table over its lifetime. Dropping columns does not affect this rule.

If new columns need to be added that would exceed this number, you must create a new table. You can use the SHOW TABLE statement and INSERT … SELECT statements to create and load the spin-off table.