Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2011-06-13 : 01:15:54
|
| hello all.I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.lili@@ |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-06-13 : 07:15:52
|
Not sure what you mean by "description". You can see the view definition by right-clicking on the view in SSMS object explorer and select Script View as -> Create to -> New Query Editor window.If you are looking for the details of the view, you can do SELECT * FROM INFORMATION_SCHEMA.columns WHERE table_name = 'myView' |
 |
|
|
|
|
|
description of view columns