Database: Does the HX app have significant value?

Question

I work with an outdated application with an unexpected surprise, next to the missing useful documentation for specifying names or for the entire data structure.

In the database, tables with one of them ending in HX are similarly named. Does this mean any value in the experience of anyones database?

It seems that the data is being replicated, so I would suggest that this is a historical table, but I just want to be sure before I fill it out.

Thanks at Advance.

Corey

Answer 1

, , . . , .

, . , , , - , , - , , , -, .

sp_depends, , .

Exec sp_depends 'table_name_hx'

, .

Answer 2

, , . , (hx_ReportingUsage), . - , .

, , . , , procs, UDF , , , , .

SQL Server, :

SELECT OBJECT_NAME(id) 
    FROM syscomments 
    WHERE [text] LIKE '%foobar%' 
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)

Answer 3

Perhaps this came from the field of medicine. They often have abbreviations such as Rx for prescription, Sx for symptoms, etc. Hx is a medical history: http://en.wikipedia.org/wiki/Medical_history . This could find a way to other fields and even databases.