SQL: SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'


query
  TABLE_CATALOG TABLE_NAME TABLE_SCHEMA TABLE_TYPE
1 silverwareconsultingdb dtproperties dbo BASE TABLE
2 silverwareconsultingdb User dbo BASE TABLE
3 silverwareconsultingdb User2 dbo BASE TABLE
4 silverwareconsultingdb UserType dbo BASE TABLE
5 silverwareconsultingdb Widget dbo BASE TABLE