List User Defined Table
select table_name from INFORMATION_SCHEMA.Tables where TABLE_TYPE ='BASE TABLE' and substring(table_name,0,4) !='sys' order by table_name.
List User Defined Procedure
Select name from sys.procedures where [type] = 'P' and is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%' order by name
List User Defined Functions
SELECT name FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' order by name