select * from sys.objects where schema_id = schema_id('hoge'); select schema_name(SYSOBJ.schema_id) as schemaname, SYSOBJ.name as relname, SINDEXES.rows as n_live_tup from sys.objects as SYSOBJ inner join sys.sysindexes as SYSINDEXES on SYSOBJ.object_id = SYSINDEXES.id and SYSINDEXES.indid < 2 where SYSOBJ.type = 'U' and schema_name(SYSOBJ.schema_id) = 'hoge' order by SYSOBJ.name;