Thread: List of database tables and stored procedures - MS SQL

Often times it comes handy if you can list database tables and stored procedures.

( i tried it with 2005 )
List of tables in MS SQL
select * from mydatabase.sys.tables

List of stored procedures in MS SQL
select * from mydatabase.sys.procedures

replace mydatabase with your database name.