SQL statement to get a View

[jeepxo]

I'm looking for a sql statement to return the text of a view.

I need to make a change to some of the fields in the view, but I can't find the text I used originally to create it.

I don't have access to Enterprise Manager or Query analyser so I need a SQL statement that I can run that will return the text used to create the view.

Any help would be appreciated.

To build may have to be the slow laborious task of years. To destroy can simply be the thoughtless act of a single day.

 

[gmmastros]

sp_helptext '[!]YourViewNameHere[/!]'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom