More than 1 year has passed since last update.

SQL Serverでテーブルごとの件数を一覧で取得する

SQLServer

Posted at 2022-07-26

SELECT OBJ.name AS TableName, IND.rows
FROM sys.objects AS OBJ
JOIN sys.sysindexes AS IND
ON OBJ.object_id = IND.id AND IND.indid < 2
WHERE OBJ.type = 'U'
ORDER BY OBJ.name;

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up