コンテンツエリア開始

Ensuring Data Integrity Locate the document in its SAP Library structure

The database system provides you with the following tools to ensure data integrity.

        Integrity rules: integrity rules that refer to a table can also be specified (see CONSTRAINT definition).

        Key: a key comprising one or more columns can be defined for each table. The database system ensures that each key is unique. A key can also consist of columns of different data types (see key definition).

        UNIQUE definition: the uniqueness of the values in other columns and column combinations can also be ensured by using other mechanisms (see UNIQUE definition for "alternate keys").

        NOT NULL: by specifying NOT NULL, you can ensure that the NULL value is not accepted in individual columns (see column definition).

        DEFAULT definition: you can define default values for each column (see DEFAULT specification).

        Referential integrity conditions: by specifying referential integrity conditions, you can declare deletion and existence dependencies between the rows in two tables (see referential CONSTRAINT definition).

        Database procedures and triggers: complex integrity rules that require access to further tables can be formulated with database procedures or triggers.

 

コンテンツエリア終了