Table wise row count:
SELECT sc .name +'.'+ ta. name TableName
,SUM( pa.rows ) RowCnt
FROM sys .tables ta
INNER JOIN sys. partitions pa
ON pa .OBJECT_ID = ta .OBJECT_ID
INNER JOIN sys. schemas sc
ON ta .schema_id = sc .schema_id
WHERE ta .is_ms_shipped = 0 AND pa. index_id IN (1 ,0)
GROUP BY sc. name,ta .name
ORDER BY SUM( pa.rows ) DESC
Table wise size details:
SELECT object_name (id) [Table Name]
,[Table Size] = convert (VARCHAR, dpages * 8 / 1024) + 'MB'
,create_date
,modify_date
FROM sysindexes i
,sys. tables t
WHERE
i.indid IN (0, 1) AND
t.object_id = i.id
ORDER BY i. dpages DESC
Object count details:
SELECT
type,
total_count = COUNT (*),
last_crdate = MAX (crdate),
last_refdate = MAX (refdate)
FROM (
SELECT
type = CASE
WHEN xtype = 'U' THEN 'table'
WHEN xtype = 'V' THEN 'view'
WHEN xtype = 'P' THEN 'procedure'
WHEN xtype IN ('FN', 'TF', 'IF') THEN 'function'
END,
crdate,
refdate
FROM sysobjects
WHERE xtype IN ('FN' , 'TF' , 'IF' , 'P' , 'U' , 'V' )
) s
GROUP BY type
