It’s easy to view MS_Description extended properties of parameters in Object Explorer, but I haven’t found an easy way to add or edit them. This functionality does exist for columns in tables and views.
Right-click an object in the Object Explorer and select MS_Description, then we can add or edit them.
We will discuss that whether we add this right-click option in Extended Properties tab.
Thank you very much!
Right-click allows adding MS_Description to a stored procedure, but not to individual parameters of the procedure. Likewise for functions. For tables, in the lower section of the object explorer where column names are displayed, you can right-click a column and add an MS_Description for it.