db_column

The db_column table contains metadata about columns in db_Table objects.

Column Name Column Datatype Column Null Option Column Comment
dbrep_iid integer not null ID of the column.
dbrep_sequencenum integer with null Sequence number of the column within the parent table.
dbrep_length integer with null Length of column datatype (if applicable based on type).
dbrep_precision integer with null Precision of the column datatype (if applicable based on type).
dbrep_scale integer with null Scale of the column datatype (if applicable based on type).
dbrep_isnullable integer1 with null Indicator whether column datatype is nullable (TRUE) or not (FALSE).
dbrep_datatypeiid integer not null Id of the datatype of the column.

Product Name: Data Transformer

Table Type: Table

Relationships:

Primary Key Related Table Related Column
dbrep_iid db_seqcolumn dbrep_iid
dbrep_iid db_indexcol dbrep_columniid


Copyright © 2006 CA. All rights reserved.