Key names size limit

Started by Stéphane Devouard, September 16, 2021, 08:35:26 AM

Previous topic - Next topic

Stéphane Devouard

Hello


I haven't found any mention of a limitation in size for a key name


Yet, the key definition dialog in the DD maintenance tool imposes a 24-char size limit to the key name entered.


Having got some training in SQL, I know that in most DB systems, primary key constraints & index names must be unique throughout a database, so I now name primary keys as 'PK_<table name>', alternate indexes as 'IX_<table name>_<sorting>' -- not to mention table names often start with a 2-4 prefix representing the sub-application module ;-)


So... Is the 24 char limit by design or are keynames allowed to be larger ?


Regards,
Stéphane Devouard
Portfolio | Work