Key

Description

Whether the column is part of the database table’s primary key.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.Key { = value }"

Parameter

Description

columnname

The column for which you want to get or set primary key status.

value

Whether the column is part of the primary key. Values are:

  • Yes – The column is part of the primary key

  • No – The column is not part of the key

Usage


In the painter

Set the value using the Rows menu, Update Properties.

Examples

Example 1

setting = dw1.Describe("empid.Key")

dw1.Modify("empid.Key=Yes")