Where are parameter descriptions stored

damvanjohan · June 16, 2017 9:24AM

We use SQL Doc to document our database, however we would like to get these descriptions to create our own documentation. For table and column descriptions we have no problem to retrieve them via a query but we also would like to get our parameter descriptions via a query. The question is where can I find these parameter descriptions? In for example, which sys function/table? Where are the stored in SQL?

Rob C · June 16, 2017 2:04PM

The descriptions are an extended property on the object, named MS_Description. I suggest that you have a look at this post for more information on MS_Description and how to access the data - https://www.simple-talk.com/sql/sql-tools/towards-the-self-documenting-sql-server-database/

I hope this helps!

Where are parameter descriptions stored

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk