17.10 - Limit On the Number of Methods You Can Associate With a UDT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

There is no fixed limit on the number of methods you can associate with a UDT. Generally speaking, the upper limit is approximately 500. The reason the limit cannot be expressed deterministically is that methods can have a variable number of parameters, and the aggregate number of method parameters affects this limit, which is due to Parser memory restrictions.