SQL Server View - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL Server View

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-10 : 07:29:01

Deepak writes "How can I get the body of the View in SQL.
sp_helptext does print the body, but i cant catch that text in any variable.

Thanks.
Deepak."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-10 : 08:58:14

You can use temporary table to catch the text of view
Refer this


Create table #t(data varchar(8000))
insert into #t Exec sp_helptext 'ttv'
Select data from #t
drop table #t

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources