TABLE  Diagnostics

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.

nametypelengthunitucddescription
namevarchar64 ID_IDENTIFIERName of object
typevarchar8 CODE_MIScSystem type of the object (U:table, V:view, F: function, P: stored proc)
countbigint8 NUMBEROptional row count, where applicable