|
|
Posted by vesta on 09/18/07 19:32
It looks to me like you create your extended properties with this
function. Are there any default functions to get the information that
has been manually entered in the description field?
Georgia
On Sep 18, 12:51 pm, "Roy Harvey (MVP)" <roy_har...@snet.net> wrote:
> That description is stored as an extended property. Look at the
> documentation of function fn_listextendedproperty for instructions on
> how to retrieve this.
>
> Roy Harvey
> Beacon Falls, CT
>
>
>
> On Tue, 18 Sep 2007 09:29:46 -0700, vesta <vesta0...@gmail.com> wrote:
> >Hi,
>
> >I'm using stored procedures to create an online data dictionary for
> >all of our dbs and I thought it would be very cool if there was a way
> >that I could somehow pull the columns description entered in the table
> >design view (lower pane) of EM. I have poked around, but have not
> >found a way. It is my suspcion that this may be impossible. Does any
> >smart person out there know?
>
> >Also want to pull pks and fks and other constraints, which I think I
> >can figure out how to do, but if anyone has any pointers, that would
> >also be appreciated.
>
> >Many Thanks,
>
> >Georgia- Hide quoted text -
>
> - Show quoted text -
Navigation:
[Reply to this message]
|