Consultar Tablas y su Cantidad de Datos

Script que permite ver el nombre de la table y su numero de filas en una base de datos.
SELECT
sysobjects.Name as NombreTabla,
sysindexes.Rows as TotalFilas
FROM
sysobjects
INNER
JOIN sysindexes
ON
sysobjects.id = sysindexes.id
WHERE
type
= ‘U’ AND sysindexes.IndId < 2
ORDER BY

 

sysobjects.Name

Leave a Reply

Your email address will not be published. Required fields are marked *