PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Key names size limit  (Read 786 times)

Stéphane Devouard

  • Diamond Member
  • *****
  • Posts: 120
  • PxPlus guru with skills in PHP, JS, C#, Java
    • View Profile
    • Stéphane's Web Resume
Key names size limit
« on: September 16, 2021, 08:35:26 AM »
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