RE: Thoughts on comments
Date: Fri, 22 Mar 2013 13:01:17 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD117CFDCDE_at_G5W2734.americas.hpqcorp.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of z b
Sent: Friday, March 22, 2013 12:25 AM
To: oracle-l_at_freelists.org
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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 22 2013 - 14:01:17 CET