This one is a little hack I found on this blog. If there's isn't one you need to create it. To edit the description find property named 'MS_Description'. In the properties dialog select Extended Properties tab - it lists all extended properties assigned to the your column. Right click column and choose Properties. In the navigation click Columns element and select column. This one you would only use when you want to add properties other than 'MS_Description'. You can extend the editor by clicking button on the right side of field.Īnother option is to go to column Extended Properties editor. Then select a column you want to describe and go to Description field in the properties editor on the bottom of the screen. Select table using a right-click and choose "Design". Let's have a look at 4 different ways you can edit table column descriptions: Option 1: Table designer Some of you might surprise you and may be the cure for the pain that using standard options was. In this article I will show you all the options (I know) to edit descriptions with SSMS. Developers and DBAs skip that step as providing descriptions is simply too painful. Compare that with capabilities of Oracle database (Oracle is 4 times more expensive).īut MS didn't bother to provide useful user interface for those metadata fields and I believe documenting database schema is second most important thing, right after design itself. In SQL Server you can add multiple custom properties to each database schema element. Interestingly, Microsoft is a leader (in my opinion) in RDBMS market in terms of metadata capabilities with their proprietary extended properties. One of its weak features is the functionality to describe tables and columns.
It's a bit annoying considering that SQL Server database is very popular and costs quite a lot of $. However, it has many shortcomings and guys at MS don't bother to do anything about it for, well, over a decade now. SQL Server Management Studio is a decent tool.
0 kommentar(er)
