Previous Topic: Contact CA Technologies

Next Topic: Datatypes

Database Schema Introduction

This guide contains the database table specifications used by the CA DLP product. It is provided to allow customers to develop additional customized database queries. To make the best use of this document, you must be familiar with relational database design and have a thorough understanding of SQL.

This guide is based on the database schema version 3.60 used by CA DLP r12.5 (build 2600 and its derivatives). A diagram showing the relationship between all documented tables is included in Table Schema Diagram.

See IDM Columns for information about column names that end with IDM.

This section contains the following topics:

Datatypes

Database Views