Repository Database
Go Up to Managing Repository Files
The Repository uses a database to store information about the Repository Diagrams and their objects. The database is updated each time a user checks out, checks in, adds, or deletes any element of a Diagram. In addition, the Repository database stores the history of certain Repository operations, as well as all security rules and data.
WARNING: Do not directly update Repository tables because the database is a transactional system designed to handle collaborative model use. Updating the Repository database outside of ER/Studio DA can corrupt the data. The SQL scripts in the Embarcadero\Repository\Utilities\MasterScripts and SQLScripts directories are used by the Repository within ER/Studio DA and should be used outside ER/Studio DA only at the request and under the guidance of Embarcadero Support.
Note: You can query the data and select data from the Repository for reporting purposes. Commonly used SQL scripts in the Embarcadero\Repository\Utilities\QueryScripts and Embarcadero\ERStudio Data Architect X.X\SQLCode\Repo_Queries directories have been provided for your convenience. However, you can create your own scripts and to help you do this, a meta model is provided in the ...\Program Files\Embarcadero\ERStudio Data Architect X.X\System Models directory.