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.
| Author |
Topic |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2008-01-17 : 17:23:29
|
| Is there any oen can tell me how i can run some system sp or exec something to list all tables or stored procedures in a database, like i use select statement to list some coulmn data? thanks in advance. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-17 : 17:46:09
|
| read up books online for sys.objects catalog view.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-17 : 17:48:29
|
| sp_ tablesor Select name from sysobjects where type = 'U'SP: Select name from sysobjects where type = 'P'Views:Select name from sysobjects where type = 'V' |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2008-01-17 : 18:16:31
|
| i got it with tables and sp. thank you both so much!!! |
|
|
|
|
|
|
list of all tables or stored procedures