Adding custom sys_schema_attribute records

[ChristopherV430]

Hello,

I'm interested in managing custom application behaviour via custom table attributes.

I know this can just be done by editing the sys_dictionary.attributes field directly but I would like to improve maintainability for future developers/maintainers by instead adding an entry to sys_schema_attribute and using sys_schema_attribute_m2m entries, same as you'd see for OOTB attributes.

When creating a sys_schema_attribute record the above message shows:

"Schema attributes are a predefined set of elements that alter the behavior of the table or column they are applied to. New attributes cannot be created, but administrators can add or remove most attributes from the schema elements to which they are applied. More Info"

The More Info link doesn't go anywhere useful and the "New attributes cannot be created" message is clearly false.

My question is:

1) What is the purpose of this message?

2) Are there any reasons not to create "sys_schema_attribute" records, from what I can tell all it would do is provide context to any custom table/field attributes. What's the downside?

Apologies if this is the incorrect forum, unsure where to post such a general platform development question.

Thank you

[Mathew Hillyard]

Hi @ChristopherV430 

Whilst this is a very interesting technical question, it isn't really relevant to the Enterprise Architecture forum.

This is a relatively small forum and it would be great to avoid polluting it with questions that are relevant to other fora, in your case probably the Developer forum. You'll hit a much wider audience and probably get a quicker and more trustworthy set of answers.

Thank you.