>>>HI
>>>
>>>I want to document (briefly) some views in a database.
>>>
>>>I can't see any way to attach some description to the view.
>>>
>>>http://www.adivo.com/doc/database/SqlServer2005.html
>>>
>>>tells me if I right click on the view I should be able to select design and add a description.
>>>
>>>But I don't get a design option if I right click (I assume that may be part of SQL2008) .
>>>
>>>Anyone know the best way to document a SQL2005 view.
>>
>>
>>Open table for design and press F4 (or View->Properties Window). That will bring you Properties Window.
>
>Thnaks Borislav.
>
>Supplementary question :-)
>
>is there a way to see view descriptions without opening each separately.
>
>Nick

Check:
http://stackoverflow.com/questions/887370/sql-server-extract-table-meta-data-description-fields-and-their-data-types