The System Security Officer must reset the allow select on syscomments.text column configuration parameter, in the evaluated configuration. (See evaluated configuration in the Glossary for more information.) When this happens, you must be the creator of the view or a System Administrator to view the text of a view through sp_helptext.
To display the text of the create view statement, execute sp_helptext:
sp_helptext hiprice
----------
1
(1 row affected)
text
--------------------------------------------
create view hiprice
as select *
from titles
where price > $15 and advance > $5000
(1 row affected, return status = 0)
If the source text of a view was encrypted using sp_hidetext, Adaptive Server displays a message advising you that the text is hidden. For information about hiding source text, see sp_hidetext in the Reference Manual.
