Friday, February 24, 2012

Documenting Tables

Is there a way to document what a tables does within Enterprise Manager? I'm
thinking no, so my next question is what is the best way to describe what a
table is used for...aside from a descriptive name. Thanks.Mike Collins wrote:
> Is there a way to document what a tables does within Enterprise
> Manager? I'm thinking no, so my next question is what is the best way
> to describe what a table is used for...aside from a descriptive name.
> Thanks.
In your database design document and logical model. You can add descriptive
information to database objects using sp_addextendedproperty
David Gugick
Quest Software|||Thanks...I also found out that you can use Query Analyzer to add/delete
extended properties.
"David Gugick" wrote:
> Mike Collins wrote:
> > Is there a way to document what a tables does within Enterprise
> > Manager? I'm thinking no, so my next question is what is the best way
> > to describe what a table is used for...aside from a descriptive name.
> > Thanks.
> In your database design document and logical model. You can add descriptive
> information to database objects using sp_addextendedproperty
>
> --
> David Gugick
> Quest Software
>
>

No comments:

Post a Comment