Skip to main content

%XSQL.Catalog.Informix.syscolumns

persistent class %XSQL.Catalog.Informix.syscolumns extends %Library.Persistent

SQL Table Name: %XSQL_Catalog_Informix.syscolumns

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property colname as %String (MAXLEN = 128);
Name of the column
Property methods: colnameDisplayToLogical(), colnameGet(), colnameIsValid(), colnameLogicalToDisplay(), colnameLogicalToOdbc(), colnameNormalize(), colnameSet()
property colno as %SmallInt [ Transient ];
Column number sequentially assigned by the system (from left to right within each table)
Property methods: colnoCompute(), colnoDisplayToLogical(), colnoGet(), colnoIsValid(), colnoLogicalToDisplay(), colnoNormalize(), colnoSQLCompute(), colnoSet(), colnoSetT()
property coltype as %SmallInt [ Transient ];
Code (identifier) for column data type: 0 = CHAR 14 = INTERVAL 1 = SMALLINT 15 = NCHAR 2 = INTEGER 16 = NVARCHAR 3 = FLOAT 17 = INT8 4 = SMALLFLOAT 18 = SERIAL8* 5 = DECIMAL 19 = SET 6 = SERIAL* 20 = MULTISET 7 = DATE 21 = LIST 8 = MONEY 22 = ROW 9 = NULL 23 = COLLECTION 10 = DATETIME 24 = ROWREF 11 = BYTE 40 = Variable-length opaque type 12 = TEXT 41 = Fixed-length opaque type 13 = VARCHAR 4118 = Named row type
Property methods: coltypeCompute(), coltypeDisplayToLogical(), coltypeGet(), coltypeIsValid(), coltypeLogicalToDisplay(), coltypeNormalize(), coltypeSQLCompute(), coltypeSet(), coltypeSetT()
property maxlen as %Integer;
Maximum column length (in bytes)
Property methods: maxlenDisplayToLogical(), maxlenGet(), maxlenIsValid(), maxlenLogicalToDisplay(), maxlenNormalize(), maxlenSet()
property tabid as %Integer [ Required ];
Object ID of the table to which this column belongs
Property methods: tabidDisplayToLogical(), tabidGet(), tabidIsValid(), tabidLogicalToDisplay(), tabidNormalize(), tabidSet()

Indexes

index (IDKEYIndex on tabid,colid) [IdKey, Type = key, Unique];
Index methods: IDKEYIndexCheck(), IDKEYIndexDelete(), IDKEYIndexExists(), IDKEYIndexOpen(), IDKEYIndexSQLCheckUnique(), IDKEYIndexSQLExists(), IDKEYIndexSQLFindPKeyByConstraint(), IDKEYIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheSQLStorage

Maps: 2

  • Map number 1 is named Master

    thismap.Global: ^oddTSQL

  • Map number 2 is named SchemaNameIndex

    thismap.Global: ^oddSQL

  • ^oddTSQL({tabid},"col",{colid})
    =
    Node Delimiter Piece Name
    1 schema
    2 parent_obj_name
    3 maxlen
    5 colno
    6 colname
    ^oddSQL({schema},{parent_obj_name},"tsql",1,{tabid},"col",{colid})
    =
FeedbackOpens in a new tab