sp_addextendedproperty 2

[JBaileys]

I do not understand how the extended property works? I have read BOL and maybe call it "the morning slowdown" - but I don't understand what the extended property does.

 

[mrdenny]

If I'm reading BOL correctly... The extended property stores user entered data such as a description about an object in SQL.

It appears that extended properties can be added to any user object, or user account.

I think that the description field in Enterprise manager when in table design view is an extended property.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[JayKusch]

MrDenny is correct in his statement of Extended Properties(EP).

Not only are you able to use the table design mode in Enterprise Manager(EM) to add the verbiage to the description area, you can also use Query Analyzer(QA) to add extended properties to most all of the objects that will accept EPs.

Open QA and if the "Object Browser" window is closed, choose from the menu bar Tools..Object Browser..Show/Hide. This will bring up the Object Browser pane on the left side of QA.

From there, drill down to any object level ... Table, view, column, Database, Index, Trigger ... and then right-click on it. You will see an option for "Extended Properties". There you will be able to add the user defined description of the object.

Of course you can also use the command as you stated in your thread name, "sp_addextendedproperty". There are a host of other EP commands. These are also the commands you will have to use to generate you list of objects and associated EPs.

Here is a link to help you out and describes what we did to create our data dictionary.

http://www.microsoft.com/sql/techinfo/tips/administration/extendedproperties.asp

Thanks

J. Kusch