PxPlus User Forum

Main Board => Discussions => Nomads => Topic started by: St├ęphane Devouard on September 16, 2021, 08:35:26 AM

Title: Key names size limit
Post by: St├ęphane Devouard 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,