IBM Support

Max length of database/table/column/user/group name

Question & Answer


Question

What is the maximum length for a database/table/column/user/group name?

Answer

For systems running IBM Netezza Performance Server 3.1 and later, the maximum length for a database/table/column/user/group is 128 characters.

The first character of a name must be alphabetic. If the name is more than the system limit, the system truncates the additional characters.

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ997842

Document Information

Modified date:
17 October 2019

UID

swg21567113