I was just wondering if you happen to know where can we find a documentation about Teradata known limits (length of variables, tablename, view, triggers, etc)?
Appreciate to hear from you soon.
Many thanks! I've found it.
however, i could not find a maximum limit on the length of a column name in a table and or other db objects for that matter. Do you happen to know this specific details or better if we do have available documentation for these information.
Thanks again for the response and looking forward to hear from you soon.
APPENDIX B Teradata System Limits
This appendix provides the following Teradata Database limits:
• System limits
• Database limits
• Session limits
The appendix also provides a list of the data types for the various system-derived and
The reported limits apply only to the platform software. Platform-dependent client limits are
not documented in this appendix.
I agree with Alexander Davis.
The limitations cause extra non-value add work and they should be changed.
Dieter, thanks for the information posted. However, it seems strange that compatability with other major vendors and alignment with defacto standards supporting long columns name isn't a TD priority.
The more TD positions itself in the marketplace as a warehouse platform for Oracle OLTP apps, the more important aligning with other vendors limitations will become.