list of customized stored procedures

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

Transact-SQL (2000)

list of customized stored procedures

Author

Topic

imughal
Posting Yak Master

192 Posts

Posted - 2004-08-31 : 06:32:06

hi,

i have database comprises of tables, stored procedures and views. now i want a list of all user created stored procedure and views.

i know how to get the tables list. like that

select * from
information_schema.tables

but i want to list the stored procedures and views. Can anyone tell me how to get the list.

thx

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-08-31 : 06:38:03

select * from sysobjects
where type in ('v', 'p')
-- v = vievs, p = sprocs

Go with the flow & have fun! Else fight the flow :)