Table length

Does anyone know the maximum tablename length on Informix?

Peter Howe wrote: > Does anyone know the maximum tablename length on Informix? Here you are: (extracted from SERVERS_7.2 release notes) Table-Level Parameters (based on 2K page size) per Table ----------------------------------------------------------------- Data rows per fragment............................. 4,277,659,295 Data pages per fragment............................... 16,775,134 Data bytes per fragment........................... 33,818,671,136 (excludes Binary Large Objects, BLOBs; roughly double this number for 4K page size) Binary Large Object bytes.................................. 2**31 Row length................................................ 32,767 Number of columns............................................ 32K Indexes....................................................... 77 (roughly double this number for 4K page size) Columns per index............................................. 16 Bytes per index.............................................. 255 Dragan Jurkovic MRRM (Canada) Inc.