dastaub
asked on
SQL 2005 - table row count
I would like to alter this query so it includes a row count for each table.
SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,' TableHasPr imaryKey') = 0
ORDER BY SchemaName, TableName;
thank you
SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,'
ORDER BY SchemaName, TableName;
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.