Skip to main content
Skip table of contents

How to count all entries of a MS SQL DigaSystem Database

If you like to know "how many entries i have in a DigaSystem Database, you can use this SQL script.
For example i need this to calculate how may entries are created day by day to calculate job processors 

SELECT t.name, t.create_date, t.modify_date ,s.row_count from sys.tables t
JOIN sys.dm_db_partition_stats s
ON t.object_id = s.object_id
AND t.type_desc = 'USER_TABLE'
AND s.index_id IN (0,1)
AND name not like '%[_]T' AND name not like '%[_]M' AND name not like '%[_]E' AND name not like '%[_]X' AND name not like '%[_]F'
AND name not like '%[_]C' AND name not like '%[_]S' AND name not like '%[_]L' AND name not like '%[_]V'
AND name != 'HISTORY' AND name != 'LOCKED' AND name != 'DEFINITION' AND name != 'COLLECTION' AND name != 'DBVERSION' AND name != 'KEYWORD'
AND name != 'DIGAS' AND name != 'DISPATCH_TASKS' AND name != 'FIELDDEF' AND name != 'REDUNDANCE' AND name != 'RESSORT' AND name != 'STATISTIC'
AND name != 'sysdiagrams' AND name != 'DEF_DEF'
order by t.modify_date DESC
--order by t.name





JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.