Table Creation

Locking and Versioning

Identity Row ID Column and Enable Row Locking

Table Creation

The command is:

sdetable -o create -t hassdemaintainedrowid -d "name string(20), fid integer(9)" -u t_user -p test

The output of the describe registration command (sdetable -o describe_reg) for this table is as follows:

NoteThe Row Lock has no value and the value of Dependent Objects is None.

Table Owner            : T_USER

Table Name             : HASSDEMAINTAINEDROWID

Registration Id        : 18111

Row ID Column          :

Row ID Column Type     :

Row Lock               :

Minimum Row ID         :

Dependent Objects      : None

Registration Date      : 02/24/05 13:08:02

Config. Keyword        : DEFAULTS

User Privileges        : SELECT, UPDATE, INSERT, DELETE

Visibility             : Visible