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?
Comments
1 comment
-
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!
Add comment
Please sign in to leave a comment.