Listar Schemas y Tablas SQL server

SELECT sys.schemas.name as schemaName, sysobjects.Name as tableName, sysindexes.Rows
FROM sysobjects
INNER JOIN sysindexes ON sysobjects.id = sysindexes.id
INNER JOIN sys.schemas ON sysobjects.uid = sys.schemas.schema_id
WHERE
    type = 'U'
    AND sysindexes.IndId < 2
ORDER BY schemaName, tableName