SQL: Exec sp_tables @table_type="'TABLE'"

query
  REMARKS TABLE_NAME TABLE_OWNER TABLE_QUALIFIER TABLE_TYPE
1 [empty string] dtproperties dbo silverwareconsultingdb TABLE
2 [empty string] User dbo silverwareconsultingdb TABLE
3 [empty string] User2 dbo silverwareconsultingdb TABLE
4 [empty string] UserType dbo silverwareconsultingdb TABLE
5 [empty string] Widget dbo silverwareconsultingdb TABLE