Nick Weavers wrote:I was wondering if I could use table and column comments to store "metadata".
I would like to know if this practice should be avoided for any specific reasons (some characters not allowed or too much overhead on the db for instance) or if it is a decent approach or Should a relation table of "labels" be created to address this issue properly? (DBA's please throw your 2 cents in =D)David Ashman's Response wrote:Just seems wrong to try and hack comment usage for actual data you want to use... in a database made to store data in the first place.
Basic example of usage in the application:
Code: Select all
loop of all queried col names and comments
{
label (comment): form input (col name)
}