servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Constants SummaryConstant used when setting or getting the sequence type of columns.Constant used when setting or getting the sequence type of columns.Constant used when setting or getting the type of columns.Constant used when setting or getting the flags of columns.Constant used when setting or getting the type of columns.Constant used when setting or getting the type of columns.Constant for column information indicating unset values.Constant used when setting or getting the type of columns.Constant used when setting or getting the row identifier type of columns.Constant used when setting or getting the row identifier type of columns.Constant used when setting or getting the sequence type of columns.Constant used when setting or getting the type of columns.Constant used when setting or getting the flags of columns.Constant used when setting or getting the sequence type of columns.servoy sSummary12%30%58%height: 30px;3Property SummaryGet or set the allow-null flag of a new column.Get or set the row identifier type of the column.Get or set the sequence type of the column.servoy sSummary12%30%58%height: 30px;3Methods SummaryGet the data provider id for this column (which is the same as name if not explicitly defined otherwise).Get the default format of the column.Get the description property of the column.Get the foreign type of the column.Get the length of the column as reported by the JDBC driver.Get the qualified name (including table name) of the column as known by the database.Returns a quoted version of the column name, if necessary, as defined by the actual database used.Get the name of the column as known by the database.Get the raw JDBC type of the column, which allows to check database specific types, like sting/byte column type variations.Get the scale of the column as reported by the JDBC driver.Get the title property of the column.Get the JDBC type of the column.Get the name JDBC type of the column.Check a flag of the column.voidSet the database sequence name of the column, used for columns with sequence type JSColumn.voidSet or clear a flag of a new column.constantservoy sDetail2100%height:30px2Constants DetailsDATABASE_IDENTITYname
DATABASE_IDENTITY
dessIndentConstant used when setting or getting the sequence type of columns.ret
dessIndentConstant used when setting or getting the flags of columns. This flag identifies columns that are skipped in the sql.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow INTEGERname
INTEGER
dessIndentConstant used when setting or getting the type of columns.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow MEDIAname
MEDIA
dessIndentConstant used when setting or getting the type of columns.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow NONEname
NONE
dessIndentConstant for column information indicating unset values.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow NUMBERname
NUMBER
dessIndentConstant used when setting or getting the type of columns.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow PK_COLUMNname
PK_COLUMN
dessIndentConstant used when setting or getting the row identifier type of columns. This value identifies columns that are defined as primary key in the database.ret
dessIndentConstant used when setting or getting the row identifier type of columns. This value identifies columns that are defined as primary key by the developer (but not in the database).ret
dessIndentGet or set the allow-null flag of a new column. Note that when a column is added to an existing table, allowNull will always be set. For a primary key column, the allowNull flag will be always off, for other columns the flag is set by default.ret
dessIndentGet or set the row identifier type of the column. The sequence type is one of: - JSColumn.PK_COLUMN - JSColumn.ROWID_COLUMN - JSColumn.NONEret
dessIndentGet or set the sequence type of the column. The sequence type is one of: - JSColumn.NONE - JSColumn.SERVOY_SEQUENCE - JSColumn.DATABASE_SEQUENCE - JSColumn.DATABASE_IDENTITY - JSColumn.UUID_GENERATOR;ret
dessIndentGet the qualified name (including table name) of the column as known by the database. The name is quoted, if necessary, as defined by the actual database used.ret
dessIndentReturns a quoted version of the column name, if necessary, as defined by the actual database used.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getSQLNamename
getSQLName()
dessIndentGet the name of the column as known by the database.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getSQLTypename
getSQLType()
dessIndentGet the raw JDBC type of the column, which allows to check database specific types, like sting/byte column type variations.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getScalename
getScale()
dessIndentGet the scale of the column as reported by the JDBC driver.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getTitlename
getTitle()
dessIndentGet the title property of the column.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow getTypename
getType()
dessIndentGet the JDBC type of the column. The type reported by the JDBC driver will be mapped to one of: - JSColumn.DATETIME - JSColumn.TEXT - JSColumn.NUMBER - JSColumn.INTEGER - JSColumn.MEDIAret
dessIndentGet the name JDBC type of the column. The same mapping as defined in JSColumn.getType() is applied.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow hasFlagname
hasFlag(flag)
dessIndentCheck a flag of the column. The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.UUID_COLUMN - JSColumn.EXCLUDED_COLUMNprs
dessIndentSet the database sequence name of the column, used for columns with sequence type JSColumn.DATABASE_SEQUENCE.prs
Parameters
sIndentsequenceNamethe sequence nameret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow setFlagname
setFlag(flag, set)
dessIndentSet or clear a flag of a new column. The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.UUID_COLUMN; - JSColumn.EXCLUDED_COLUMN;prs
Parameters
sIndentflagthe flag to setsettrue for set flag, false for clear flagret