I found this to be the most useful.

select name from sysobjects where type='U'
' Type U = User Tables
' Type P = User Stored Procedures


this will return all the user defined tables or procedures if needed.


HTH
Mitch Spruill