stored procedure for viewing views... 
Author Message
 stored procedure for viewing views...
Are there any stored procedures similar to sp_help that
will give you information about views, like relationships,
source tables for each field, etc?  In addition are their
any stored procedures that will show you the contents of a
stored procedure.

Thanks in advance.

Robert



Wed, 19 Oct 2005 00:41:36 GMT
 stored procedure for viewing views...

Check out sp_helptext in the BOL.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional

www.pinnaclepublishing.com/sql

Are there any stored procedures similar to sp_help that
will give you information about views, like relationships,
source tables for each field, etc?  In addition are their
any stored procedures that will show you the contents of a
stored procedure.

Thanks in advance.

Robert



Wed, 19 Oct 2005 00:43:35 GMT
 stored procedure for viewing views...
Tom,

Thanks!!!  That was exactly what I was looking for.  I
glanced through the list of sp's in BOL yesterday, but
when I saw sp_helptext, I assumed it was about text
searches.  

BTW- Great article "Who's In Charge".  I never thought
about using an EXISTS as a JOIN condition.  I'm looking
forward to getting your book.

Thanks again,

Robert



Wed, 19 Oct 2005 01:14:55 GMT
 stored procedure for viewing views...

Uh, thank you.  Thank you very much.  ;-)

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional

www.pinnaclepublishing.com/sql

Tom,

Thanks!!!  That was exactly what I was looking for.  I
glanced through the list of sp's in BOL yesterday, but
when I saw sp_helptext, I assumed it was about text
searches.  

BTW- Great article "Who's In Charge".  I never thought
about using an EXISTS as a JOIN condition.  I'm looking
forward to getting your book.

Thanks again,

Robert



Wed, 19 Oct 2005 02:01:31 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Please help to convert view on views to stored procedure

2. Please help to convert view on views to stored procedure

3. Stored procedure dependancy on tables, views and other stored procedures

4. temporary tables in stored procedures/parameter views vs stored procedures

5. View what stored procedures are currently in the procedure cache

6. Stored Procedures & Views - where are they stored

7. How are views on views on views executed ??

8. Unable to Design tablles, view and stored procs etc using Data View

9. Stored Procedures v Views

10. Report/Stored procedure/View?

11. Calling a view from a stored procedure

12. stored procedures, views and database context


 
Powered by phpBB® Forum Software