Transact-SQL - Schema

Stored Procedures

SELECT * FROM sys.procedures ORDER BY [name]

Tables

EXEC sp_tables @TABLE_TYPE="'TABLE'"
SELECT name, user_name(uid), * FROM sysobjects WHERE type='U'