15.00 - Maximum Number of Columns Per Table - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.