SQL Server 2014 - How to list a view

Define 'list a view'.  Perhaps..

SELECT * FROM sys.views

Select allOpen in new window

No, I'm looking for a list of views. I'm looking for how to list the "create view ..." etc. of a given view.

I get the error "There is no text for object 'myview'"

Did you run the command in the correct database? Also, verify if you added the schema name.

use databasename
go
sp_helptext @objname = 'schema.myview'

Select allOpen in new window

Well, here's the interesting thing. When I run the sp_helptext in the Server Management Studio, it works. When I run it from a remote host inside an java program I get:

Select Failed: 15197 There is no text for object 'myview'

This is true whether I use a Microsoft jdbc driver or a 3rd party driver.

However, if I run the same procedure from the same java program connecting to the SQL Server 2005 database, it works.

Thoughts?

Ah ha! That's the problem. I ran using 'sa' in SSMS, but a normal user in the java program. When I ran as 'sa' with the java program, it worked.

Now I just have to give VIEW DEFINITION priv to the normal user.

Yup, I did "grant view definition to public" and that solved the problem. Thanks!