15.00 - 3919 Table has too many columns. - Teradata Database

Teradata Database Messages

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

3919 Table has too many columns.

Explanation:

A user table or an internal table (spool file) has too many fields. User defined tables and macros are limited to 2048 columns. Spool files may have more, for sort keys, etc., but are limited to 2560.

Generated By:

RES and OPT modules.

For Whom:

User.

Remedy:

Tables and views cannot be created or modified to have more than 2048 columns. Response rows and rows of spool tables used in joins are also restricted.