Regarding the USM_TRIGGER_DELETE_ALL_TABLE:
This is a trigger associated with the ca_contact table. The triggers do not store data. Here is the definition of this object that might be helpful:
In SQL Server, triggers are database objects, actually, a special kind of stored procedure, which “reacts” to certain actions we make in the database. The main idea behind triggers is that they always perform an action in case some event happens. If we’re talking about DML triggers, these changes shall be changes in our data
This is a package and does not store any data. Here is the definition of a SQL Package:
Packages are schema objects that group logically related PL/SQL types, variables, and subprograms.
A package will have two mandatory parts:
Package body or definition