RE: Thoughts on comments
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Mar 2013 13:01:17 +0000
We require new programs to have a table comment. Sometimes the developers add
column comments. There are times where the comments have proved useful to
developers who were not involved when the table/application was developed.
If you drop the table the comments go away. This can be an issue if your code
generation procedures/scripts do not capture the comments.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of z b
Sent: Friday, March 22, 2013 12:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Thoughts on comments
Listers,
Just wanted to get a general opinion on using comments in the database. For
example COMMENT ON COLUMN table.column "No comment".
Does anyone do this as a regular best practice? I would prefer to see this
abstraction in a data model, maybe not pushed to the database layer, especially
since not all RDBMS engines have "comment"
functionality.
The thought is we should do this for every column, every table, every oracle
db. This ends up being several million comments added to the our various
instances.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
