Re: Thoughts on comments
- From: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Mar 2013 07:53:16 -0400
If you keep them in the data model, you assume that everyone has a copy
of the data model.
If you put them in the database, then folks using your database will
have access to your comments.
I prefer both - write at design time in your data model, and also
include in your database objects. I've had to help too many end users
with poorly documented systems to rely on having a good data model around.
Jeff
On 3/22/2013 12:25 AM, z b wrote:
> 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:
