Each row in the SYSUSERMESSAGE system view holds a user-defined message for an error condition. The underlying system table for this view is ISYSUSERMESSAGE.
Previous versions of the catalog contained a SYSUSERMESSAGES system table. That table has been renamed to be ISYSUSERMESSAGE (without an 'S'), and is the underlying table for this view.
|Column name||Column type||Column constraint|
|uid||UNSIGNED INT||NOT NULL|
error A unique identifying number for the error condition.
uid The user number that defined the message.
description The message corresponding to the error condition.
UNIQUE (error, langid)