SQLServerで、テーブルの行数を、スキーマ名とテーブル名でソートして抽出するSQL

SQL Server 2012

2017.11.05

SQL Server 2012


select schemaname, tblname, rowcnt
from (
select
schema_name(SYSOBJ.schema_id) as schemaname,
SYSOBJ.name as tblname,
SYSINDEXES.rows as rowcnt
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'
) as t
order by schemaname, tblname;

select schemaname, tblname, rowcnt

from (

select

schema_name(SYSOBJ.schema_id) as schemaname,

SYSOBJ.name as tblname,

SYSINDEXES.rows as rowcnt

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'

) as t

order by schemaname, tblname;

タイトルとURLをコピーしました