<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > Database Tables Tools > Database Diagnostics SP_HELP |
Report Name: Database Diagnostics SP_HELP (example)
File Name: EarthSoft.Reports.Library.21633.dll
Dependencies: N/A
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install
Language: English
Output Type: Excel1
Description: The Database Diagnostics Report provides information on the owner, type and CREATED_DATETIME of a selected object or the name, owner, and type of all objects in the database if you do not select a specific object.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.
Overview:
To run this report, select one database Object from the tables list.
Source Tables SYS.ALL_OBJECTS, MASTER.DBO.SPT_VALUES, SYS.TYPES, SYS.ALL_COLUMNS, SYS.COLUMNS, SYS.ALL_PARAMETERS, SYSDEPENDS, SYS.IDENTITY_COLUMNS
Report Parameters |
||
---|---|---|
|
Report Output |
||
---|---|---|
Sheet 1: Name Owner Type Created_datetime
Sheet 2: Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation |
Sheet 3: Identity Seed Increment Not For Replication
Sheet 4: RowGuidCol
Sheet 5: Data_located_on_filegroup
Sheet 6: index_name index_description index_keys |
Sheet 7: constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
Sheet 8: Table is referenced by foreign key |
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021