>>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