PxPlus User Forum
Main Board => Discussions => Nomads => Topic started 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,