SQL: SELECT * FROM INFORMATION_SCHEMA.TABLES

query
  TABLE_CATALOG TABLE_NAME TABLE_SCHEMA TABLE_TYPE
1 silverwareconsultingdb dtproperties dbo BASE TABLE
2 silverwareconsultingdb sysconstraints dbo VIEW
3 silverwareconsultingdb syssegments dbo VIEW
4 silverwareconsultingdb User dbo BASE TABLE
5 silverwareconsultingdb User2 dbo BASE TABLE
6 silverwareconsultingdb UserType dbo BASE TABLE
7 silverwareconsultingdb vwUser dbo VIEW
8 silverwareconsultingdb Widget dbo BASE TABLE