Getting list of Tables which are having a Row Count is Zero.

SELECT '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS FULL_TABLE_NAME,
SCHEMA_NAME(t.schema_id) AS SCHEMA_NAME,t.name AS TABLE_NAME,
i.rows as ROW_COUNT
FROM sys.tables AS t 
INNER JOIN
sys.sysindexes AS i 
ON t.object_id = i.id 
AND i.indid < 2
where rows = 0
order by 1;