ISecurityConnection.Checks

Syntax

Checks(TableName: String): IDalCursor;

Parameters

TableName. Physical name of the table, which constraints information should be obtained.

Description

The Checks property returns the cursor with constraints metadata for the specified table.

Example

Executing the example requires that the repository contains a database with the DB identifier. The database contains a table named TABLE_1

Add links to the Dal, Db, and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    DB: IDatabaseInstance;
    Checks: IDalCursor;
    Field: IDalCursorField;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("DB").Open(Null) As IDatabaseInstance;
    Checks := DB.Connection.Checks("TABLE_1");
    While Not Checks.Eof Do
        For Each Field In Checks.Fields Do
            Debug.WriteLine(Field.Name + ": " + Field.Value);
        End For;
        Debug.WriteLine("");
        Checks.Next;
    End While;
    Checks.Close;
End Sub UserProc;

After executing the example a connection is established to the database server, to which the specified database is set up. The development environment console will display system information about table constraints.

See also:

ISecurityConnection