Re: Design Table; Columns/Description get with SP???
- From: vesta <vesta0424@xxxxxxxxx>
- Date: Tue, 18 Sep 2007 12:32:28 -0700
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...@xxxxxxxx> 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...@xxxxxxxxx> 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 -
.
- Follow-Ups:
- Re: Design Table; Columns/Description get with SP???
- From: Roy Harvey (MVP)
- Re: Design Table; Columns/Description get with SP???
- From: Erland Sommarskog
- Re: Design Table; Columns/Description get with SP???
- References:
- Design Table; Columns/Description get with SP???
- From: vesta
- Re: Design Table; Columns/Description get with SP???
- From: Roy Harvey (MVP)
- Design Table; Columns/Description get with SP???
- Prev by Date: Design Table; Columns/Description get with SP???
- Next by Date: Comparing databases
- Previous by thread: Re: Design Table; Columns/Description get with SP???
- Next by thread: Re: Design Table; Columns/Description get with SP???
- Index(es):
Relevant Pages
|
