|
This view unifies all catalog views (or system tables on SQL 2000) that create objects) that describe objects tracked by AbaPerls. That is, beside sysobjects/sys.objects, the view also covers sys.indexes, sys.types, sys.assemblies, sys.stats. The view is used by ap_sob_report_suspects_sp and ap_zz_sob_load_sp. The view only includes objects that are shipped by Microsoft, or generated by SQL Server (for instance auto-stats).
The columns are: name - The name of the object.
type - The object type. See abaobjecttypes for a list of values.
crdate - Date when the object last was modified (except for tables where it is the createion date). NULL for objects where SQL Server does not track this:.
parent - Name of parent object, if any. |
|
|
|