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

SQL Server

2017.11.052023.07.04


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をコピーしました