| This table stores a full diagnostic snapshot of the database. |
| The table contains the names of all the tables, views, stored procedures and user defined functions in the database. We leave out the Diagnostics itself, QueryResults and LoadEvents, etc these can be dynamically updated. We compute the row counts for each table and view. This is generated by running the stored procedure spMakeDiagnostics. The table was replicated upon the creation of the database into SiteDiagnostics. |
| name | type | length | unit | ucd | description |
| name | varchar | 64 | ID_IDENTIFIER | Name of object | |
| type | varchar | 8 | CODE_MISc | System type of the object (U:table, V:view, F: function, P: stored proc) | |
| count | bigint | 8 | NUMBER | Optional row count, where applicable |