MSSQL, MYSQL DB용량및 DB별 테이블 로우수 구하기

--========== MSSQL ==========

---- db별 용량 조회----
USE master;
GO
EXEC sp_databases;

----db별 테이블 건수조회 ----
USE DB NAME;
SELECT
o.name,
i.rows
FROM sysindexes i
INNER JOIN sysobjects o
ON i.id = o.id
WHERE i.indid < 2 AND o.xtype = 'U' ORDER BY o.name;



--========== MYSQL ==========

---- db별 용량 조회----
SELECT table_schema "Database Name",
  SUM(data_length + index_length) / 1024 / 1024 "Size(MB)"
FROM information_schema.TABLES GROUP BY table_schema;




----db별 테이블 건수조회 ----
SELECT TABLE_NAME, TABLE_ROWS
  FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_SCHEMA = 'DB NAME';