Dear HeidiSQL Enthusiasts and Developers
Row count in MS SQL Server does not work at all.
Can you please include the following proper query for MS SQL that will work with any MS SQL Server:
SELECT
OBJECT_SCHEMA_NAME(p.object_id) AS [Schema]
,OBJECT_NAME(p.object_id) AS [Table]
,sum(p.rows) AS [Row Count]
FROM sys.partitions p
WHERE 1=1
and p.index_id in (0,1)
and OBJECT_NAME(p.object_id) = @tableNameInHeidiSQLList
GROUP BY OBJECT_SCHEMA_NAME(p.object_id)
,OBJECT_NAME(p.object_id)
Would be easier if there were a separate settings file containing the SQL queries that HeidiSQL uses for row counts, object lists etc. Then I would be able to adjust the row count query.
Please let me know if you can add this query to HeidiSQL.