Page History

Wiki Markup
{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#DATETIME#DATABASE_IDENTITY]
Constant used when setting or getting the sequence type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#INTEGER#DATABASE_SEQUENCE]
Constant used when setting or getting the sequence type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#MEDIA#DATETIME]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#NUMBER#EXCLUDED_COLUMN]
Constant used when setting or getting the typeflags of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#TEXT#INTEGER]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tabletbody}\\ 

{table:id=|class=servoy sSummary{tr}{colgrouptd}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{[Number]{td}{td}[#MEDIA]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[BooleanNumber]{td}{td}[#getAllowNull#NONE]\()
GetConstant the allow\-null flag of the columnfor column information indicating unset values.{td}{tr}{tbody}{tbody}{tr}{td}[StringNumber]{td}{td}[#getDataProviderID]\()
Get the data provider id (name) for this column#NUMBER]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[StringNumber]{td}{td}[#getDescription]\()
Get the description property of the column#PK_COLUMN]
Constant used when setting or getting the row identifier type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[StringNumber]{td}{td}[#getForeignType]\()
Get#ROWID_COLUMN]
Constant used when setting or getting the foreignrow identifier type of the columncolumns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getLength]\()
Get the length of the column as reported by the JDBC driver#SERVOY_SEQUENCE]
Constant used when setting or getting the sequence type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[StringNumber]{td}{td}[#getQualifiedName]\()
Get the qualified name (including table name) of the column as known by the database#TEXT]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[StringNumber]{td}{td}[#getQuotedSQLName]\()
Returns a quoted version of the column name, if necessary, as defined by the actual database used#UUID_COLUMN]
Constant used when setting or getting the flags of columns.{td}{tr}{tbody}{tbody}{tr}{td}[StringNumber]{td}{td}[#getSQLName]\()
Get the name of the column as known by the database#UUID_GENERATOR]
Constant used when setting or getting the sequence type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getScale]\()
Get the scale of the column as reported by the JDBC driver.{td{table}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tbody}{tr}{td}[StringBoolean]{td}{td}[#getTitle#getAllowNull]\()
Get the title propertyallow\-null flag of the column.{td}{tr}{tbody}{tbody}{tr}{td}[NumberString]{td}{td}[#getType#getDataProviderID]\()
Get the JDBC type of the columndata provider id for this column (which is the same as name if not explicitly defined otherwise).{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getTypeAsString#getDescription]\()
Get the namedescription JDBCproperty type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[BooleanString]{td}{td}[#isRowIdentifier#getForeignType]\()
IsGet thisthe columnforeign onetype of the row identifiers for its tablecolumn.{td}{tr}{tbody}{tbody}{tr}{td}[BooleanNumber]{td}{td}[#isUUID#getLength]\()
Is thisGet the length of the column as markedreported asby UUID column.{td}{tr}{tbody}{table}\\ 

{table:id=constant|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=DATETIMEthe JDBC driver.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getQualifiedName]\()
Get the qualified name (including table name) of the column as known by the database.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getQuotedSQLName]\()
Returns a quoted version of the column name, if necessary, as defined by the actual database used.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getRowIdentifierType]\()
Get the row identifier type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getSQLName]\()
Get the name of the column as known by the database.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getScale]\()
Get the scale of the column as reported by the JDBC driver.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getSequenceType]\()
Get the sequence type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getTitle]\()
Get the title property of the column.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getType]\()
Get the JDBC type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getTypeAsString]\()
Get the name JDBC type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#hasFlag]\(flag)
Check a flag of the column.{td}{tr}{tbody}{table}\\ 

{table:id=constant|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=DATABASE_IDENTITY|class=node}{tr:id=name}{td}h6.DATABASE_IDENTITY{td}{tr}{tr:id=des}{td}{sub-section:DATABASE_IDENTITY_des|text=|trigger=button}{sub-section}{sub-section:DATABASE_IDENTITY_des|trigger=none|class=sIndent}Constant used when setting or getting the sequence type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:DATABASE_IDENTITY_snc|text=|trigger=button}{sub-section}{sub-section:DATABASE_IDENTITY_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DATABASE_IDENTITY_prs|text=|trigger=button}{sub-section}{sub-section:DATABASE_IDENTITY_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DATABASE_IDENTITY_ret|text=|trigger=button}{sub-section}{sub-section:DATABASE_IDENTITY_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DATABASE_IDENTITY_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATABASE_IDENTITY_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DATABASE_IDENTITY_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATABASE_IDENTITY_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DATABASE_IDENTITY_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATABASE_IDENTITY_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=DATABASE_SEQUENCE|class=node}{tr:id=name}{td}h6.DATABASE_SEQUENCE{td}{tr}{tr:id=des}{td}{sub-section:DATABASE_SEQUENCE_des|text=|trigger=button}{sub-section}{sub-section:DATABASE_SEQUENCE_des|trigger=none|class=sIndent}Constant used when setting or getting the sequence type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:DATABASE_SEQUENCE_snc|text=|trigger=button}{sub-section}{sub-section:DATABASE_SEQUENCE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DATABASE_SEQUENCE_prs|text=|trigger=button}{sub-section}{sub-section:DATABASE_SEQUENCE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DATABASE_SEQUENCE_ret|text=|trigger=button}{sub-section}{sub-section:DATABASE_SEQUENCE_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DATABASE_SEQUENCE_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATABASE_SEQUENCE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DATABASE_SEQUENCE_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATABASE_SEQUENCE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DATABASE_SEQUENCE_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATABASE_SEQUENCE_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=DATETIME|class=node}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:DATETIME_des|text=|trigger=button}{sub-section}{sub-section:DATETIME_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:DATETIME_snc|text=|trigger=button}{sub-section}{sub-section:DATETIME_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DATETIME_prs|text=|trigger=button}{sub-section}{sub-section:DATETIME_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DATETIME_ret|text=|trigger=button}{sub-section}{sub-section:DATETIME_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DATETIME_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATETIME_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DATETIME_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATETIME_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DATETIME_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATETIME_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=EXCLUDED_COLUMN|class=node}{tr:id=name}{td}h6.EXCLUDED_COLUMN{td}{tr}{tr:id=des}{td}{sub-section:EXCLUDED_COLUMN_des|text=|trigger=button}{sub-section}{sub-section:EXCLUDED_COLUMN_des|trigger=none|class=sIndent}Constant used when setting or getting the flags of columns.
This flag identifies columns that are skipped in the sql.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:EXCLUDED_COLUMN_snc|text=|trigger=button}{sub-section}{sub-section:EXCLUDED_COLUMN_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:EXCLUDED_COLUMN_prs|text=|trigger=button}{sub-section}{sub-section:EXCLUDED_COLUMN_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EXCLUDED_COLUMN_ret|text=|trigger=button}{sub-section}{sub-section:EXCLUDED_COLUMN_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:EXCLUDED_COLUMN_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EXCLUDED_COLUMN_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EXCLUDED_COLUMN_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EXCLUDED_COLUMN_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EXCLUDED_COLUMN_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EXCLUDED_COLUMN_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=INTEGER|class=node}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:INTEGER_des|text=|trigger=button}{sub-section}{sub-section:INTEGER_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:INTEGER_snc|text=|trigger=button}{sub-section}{sub-section:INTEGER_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:INTEGER_prs|text=|trigger=button}{sub-section}{sub-section:INTEGER_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:INTEGER_ret|text=|trigger=button}{sub-section}{sub-section:INTEGER_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:INTEGER_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:INTEGER_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:INTEGER_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:INTEGER_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:INTEGER_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:INTEGER_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=MEDIA|class=node}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:MEDIA_des|text=|trigger=button}{sub-section}{sub-section:MEDIA_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:MEDIA_snc|text=|trigger=button}{sub-section}{sub-section:MEDIA_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:MEDIA_prs|text=|trigger=button}{sub-section}{sub-section:MEDIA_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:MEDIA_ret|text=|trigger=button}{sub-section}{sub-section:MEDIA_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:MEDIA_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIA_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:MEDIA_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIA_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:MEDIA_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIA_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=NONE|class=node}{tr:id=name}{td}h6.NONE{td}{tr}{tr:id=des}{td}{sub-section:NONE_des|text=|trigger=button}{sub-section}{sub-section:NONE_des|trigger=none|class=sIndent}Constant for column information indicating unset values.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:NONE_snc|text=|trigger=button}{sub-section}{sub-section:NONE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:NONE_prs|text=|trigger=button}{sub-section}{sub-section:NONE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:NONE_ret|text=|trigger=button}{sub-section}{sub-section:NONE_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:NONE_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NONE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:NONE_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NONE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:NONE_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NONE_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=NUMBER|class=node}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:NUMBER_des|text=|trigger=button}{sub-section}{sub-section:NUMBER_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:NUMBER_snc|text=|trigger=button}{sub-section}{sub-section:NUMBER_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:NUMBER_prs|text=|trigger=button}{sub-section}{sub-section:NUMBER_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:NUMBER_ret|text=|trigger=button}{sub-section}{sub-section:NUMBER_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:NUMBER_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBER_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:NUMBER_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBER_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:NUMBER_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBER_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=PK_COLUMN|class=node}{tr:id=name}{td}h6.PK_COLUMN{td}{tr}{tr:id=des}{td}{sub-section:PK_COLUMN_des|text=|trigger=button}{sub-section}{sub-section:PK_COLUMN_des|trigger=none|class=sIndent}Constant used when setting or getting the row identifier type of columns.
This value identifies columns that are defined as primary key in the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:PK_COLUMN_snc|text=|trigger=button}{sub-section}{sub-section:PK_COLUMN_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:PK_COLUMN_prs|text=|trigger=button}{sub-section}{sub-section:PK_COLUMN_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:PK_COLUMN_ret|text=|trigger=button}{sub-section}{sub-section:PK_COLUMN_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:PK_COLUMN_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:PK_COLUMN_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:PK_COLUMN_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:PK_COLUMN_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:PK_COLUMN_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:PK_COLUMN_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getRowIdentifierType())
{
case JSColumn.NONE:
	// handle normal column
break;

case JSColumn.PK_COLUMN:
	// handle database pk column
break;

case JSColumn.ROWID_COLUMN:
	// handle developer defined pk column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ROWID_COLUMN|class=node}{tr:id=name}{td}h6.ROWID_COLUMN{td}{tr}{tr:id=des}{td}{sub-section:ROWID_COLUMN_des|text=|trigger=button}{sub-section}{sub-section:ROWID_COLUMN_des|trigger=none|class=sIndent}Constant 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).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ROWID_COLUMN_snc|text=|trigger=button}{sub-section}{sub-section:ROWID_COLUMN_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:ROWID_COLUMN_prs|text=|trigger=button}{sub-section}{sub-section:ROWID_COLUMN_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:ROWID_COLUMN_ret|text=|trigger=button}{sub-section}{sub-section:ROWID_COLUMN_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ROWID_COLUMN_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ROWID_COLUMN_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ROWID_COLUMN_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ROWID_COLUMN_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ROWID_COLUMN_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ROWID_COLUMN_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getRowIdentifierType())
{
case JSColumn.NONE:
	// handle normal column
break;

case JSColumn.PK_COLUMN:
	// handle database pk column
break;

case JSColumn.ROWID_COLUMN:
	// handle developer defined pk column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=SERVOY_SEQUENCE|class=node}{tr:id=name}{td}h6.DATETIMESERVOY_SEQUENCE{td}{tr}{tr:id=des}{td}{sub-section:DATETIMESERVOY_SEQUENCE_des|text=|trigger=button}{sub-section}{sub-section:DATETIMESERVOY_SEQUENCE_des|trigger=none|class=sIndent}Constant used when setting or getting the sequence type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:DATETIMESERVOY_SEQUENCE_snc|text=|trigger=button}{sub-section}{sub-section:DATETIMESERVOY_SEQUENCE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DATETIMESERVOY_SEQUENCE_prs|text=|trigger=button}{sub-section}{sub-section:DATETIMESERVOY_SEQUENCE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DATETIMESERVOY_SEQUENCE_ret|text=|trigger=button}{sub-section}{sub-section:DATETIMESERVOY_SEQUENCE_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DATETIMESERVOY_SEQUENCE_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATETIMESERVOY_SEQUENCE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DATETIMESERVOY_SEQUENCE_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATETIMESERVOY_SEQUENCE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DATETIMESERVOY_SEQUENCE_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DATETIMESERVOY_SEQUENCE_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
switch (column.getTypegetSequenceType())
{
case JSColumn.TEXTNONE:
	// handle text columncolumn with no sequence
break;

case JSColumn.NUMBER:
case JSColumn.INTEGERUUID_GENERATOR:
	// handle uuid numericalgenerated column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=INTEGERTEXT|class=node}{tr:id=name}{td}h6.INTEGERTEXT{td}{tr}{tr:id=des}{td}{sub-section:INTEGERTEXT_des|text=|trigger=button}{sub-section}{sub-section:INTEGERTEXT_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:INTEGERTEXT_snc|text=|trigger=button}{sub-section}{sub-section:INTEGERTEXT_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:INTEGERTEXT_prs|text=|trigger=button}{sub-section}{sub-section:INTEGERTEXT_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:INTEGERTEXT_ret|text=|trigger=button}{sub-section}{sub-section:INTEGERTEXT_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:INTEGERTEXT_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:INTEGERTEXT_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:INTEGERTEXT_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:INTEGERTEXT_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:INTEGERTEXT_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:INTEGERTEXT_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=MEDIAUUID_COLUMN|class=node}{tr:id=name}{td}h6.MEDIAUUID_COLUMN{td}{tr}{tr:id=des}{td}{sub-section:MEDIAUUID_COLUMN_des|text=|trigger=button}{sub-section}{sub-section:MEDIAUUID_COLUMN_des|trigger=none|class=sIndent}Constant used when setting or getting the typeflags of columns.
This flag identifies columns whose values are treated as UUID.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:MEDIAUUID_COLUMN_snc|text=|trigger=button}{sub-section}{sub-section:MEDIAUUID_COLUMN_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:MEDIAUUID_COLUMN_prs|text=|trigger=button}{sub-section}{sub-section:MEDIAUUID_COLUMN_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:MEDIAUUID_COLUMN_ret|text=|trigger=button}{sub-section}{sub-section:MEDIAUUID_COLUMN_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:MEDIAUUID_COLUMN_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIAUUID_COLUMN_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:MEDIAUUID_COLUMN_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIAUUID_COLUMN_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:MEDIAUUID_COLUMN_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIAUUID_COLUMN_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
switchif (column.getTypehasFlag(JSColumn.UUID_COLUMN))
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
uuid column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=NUMBERUUID_GENERATOR|class=node}{tr:id=name}{td}h6.NUMBERUUID_GENERATOR{td}{tr}{tr:id=des}{td}{sub-section:NUMBERUUID_GENERATOR_des|text=|trigger=button}{sub-section}{sub-section:NUMBERUUID_GENERATOR_des|trigger=none|class=sIndent}Constant used when setting or getting the sequence type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:NUMBERUUID_GENERATOR_snc|text=|trigger=button}{sub-section}{sub-section:NUMBERUUID_GENERATOR_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:NUMBERUUID_GENERATOR_prs|text=|trigger=button}{sub-section}{sub-section:NUMBERUUID_GENERATOR_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:NUMBERUUID_GENERATOR_ret|text=|trigger=button}{sub-section}{sub-section:NUMBERUUID_GENERATOR_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:NUMBERUUID_GENERATOR_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBERUUID_GENERATOR_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:NUMBERUUID_GENERATOR_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBERUUID_GENERATOR_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:NUMBERUUID_GENERATOR_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBERUUID_GENERATOR_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
switch (column.getTypegetSequenceType())
{
case JSColumn.TEXTNONE:
	// handle column textwith no columnsequence
break;

case JSColumn.NUMBERUUID_GENERATOR:
case
JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div} uuid generated column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=getAllowNull|class=node}{tr:id=name}{td}h6.getAllowNull{td}{tr}{tr:classid=lastDetailRowsig}{td}{td}{tr}{tbody}{tbodyspan:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=TEXTiets|class=node}{tr:id=name}{td}h6.TEXTstyle=float: left; font-weight: bold;}getAllowNull{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:TEXTgetAllowNull_des|text=|trigger=button}{sub-section}{sub-section:TEXTgetAllowNull_des|trigger=none|class=sIndent}ConstantGet used when setting or getting the type of columnsthe allow\-null flag of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TEXTgetAllowNull_snc|text=|trigger=button}{sub-section}{sub-section:TEXTgetAllowNull_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TEXTgetAllowNull_prs|text=|trigger=button}{sub-section}{sub-section:TEXTgetAllowNull_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TEXTgetAllowNull_ret|text=|trigger=button}{sub-section}{sub-section:TEXTgetAllowNull_ret|trigger=none|class=sIndent}[Number]Boolean] -- boolean allow-null flag.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TEXTgetAllowNull_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:TEXTgetAllowNull_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TEXTgetAllowNull_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:TEXTgetAllowNull_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TEXTgetAllowNull_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:TEXTgetAllowNull_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
switchif (!column.getTypegetAllowNull())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER: 	// handle numerical column break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{thcannot be null
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getAllowNullgetDataProviderID|class=node}{tr:id=name}{td}h6.getAllowNullgetDataProviderID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[BooleanString]{span}{span:id=iets|style=float: left; font-weight: bold;}getAllowNullgetDataProviderID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getAllowNullgetDataProviderID_des|text=|trigger=button}{sub-section}{sub-section:getAllowNullgetDataProviderID_des|trigger=none|class=sIndent}Get the allow\-null flag of the column data provider id for this column (which is the same as name if not explicitly defined otherwise).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getAllowNullgetDataProviderID_snc|text=|trigger=button}{sub-section}{sub-section:getAllowNullgetDataProviderID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getAllowNullgetDataProviderID_prs|text=|trigger=button}{sub-section}{sub-section:getAllowNullgetDataProviderID_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getAllowNullgetDataProviderID_ret|text=|trigger=button}{sub-section}{sub-section:getAllowNullgetDataProviderID_ret|trigger=none|class=sIndent}[BooleanString] -- booleanString allow-nulldataprovider flagid.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getAllowNullgetDataProviderID_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getAllowNullgetDataProviderID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getAllowNullgetDataProviderID_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getAllowNullgetDataProviderID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getAllowNullgetDataProviderID_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getAllowNullgetDataProviderID_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
var dataProviderId if= (!column.getAllowNullgetDataProviderID())
{
	 // column cannot be
null
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getDataProviderIDgetDescription|class=node}{tr:id=name}{td}h6.getDataProviderIDgetDescription{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDataProviderIDgetDescription{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getDataProviderIDgetDescription_des|text=|trigger=button}{sub-section}{sub-section:getDataProviderIDgetDescription_des|trigger=none|class=sIndent}Get the datadescription providerproperty idof (name) for this the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDataProviderIDgetDescription_snc|text=|trigger=button}{sub-section}{sub-section:getDataProviderIDgetDescription_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getDataProviderIDgetDescription_prs|text=|trigger=button}{sub-section}{sub-section:getDataProviderIDgetDescription_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getDataProviderIDgetDescription_ret|text=|trigger=button}{sub-section}{sub-section:getDataProviderIDgetDescription_ret|trigger=none|class=sIndent}[String] -- String dataprovidercolumn iddescription.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDataProviderIDgetDescription_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDataProviderIDgetDescription_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDataProviderIDgetDescription_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDataProviderIDgetDescription_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDataProviderIDgetDescription_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDataProviderIDgetDescription_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customeridcustomername')
var dataProviderIddesc = column.getDataProviderIDgetDescription()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getDescriptiongetForeignType|class=node}{tr:id=name}{td}h6.getDescriptiongetForeignType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDescriptiongetForeignType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getDescriptiongetForeignType_des|text=|trigger=button}{sub-section}{sub-section:getDescriptiongetForeignType_des|trigger=none|class=sIndent}Get the description property of the column=none|class=sIndent}Get the foreign type of the column.
The foreign type can be defined design time as a foreign key reference to another table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDescriptiongetForeignType_snc|text=|trigger=button}{sub-section}{sub-section:getDescriptiongetForeignType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getDescriptiongetForeignType_prs|text=|trigger=button}{sub-section}{sub-section:getDescriptiongetForeignType_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getDescriptiongetForeignType_ret|text=|trigger=button}{sub-section}{sub-section:getDescriptiongetForeignType_ret|trigger=none|class=sIndent}[String] -- String columnforeign descriptiontype.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDescriptiongetForeignType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDescriptiongetForeignType_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDescriptiongetForeignType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDescriptiongetForeignType_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDescriptiongetForeignType_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDescriptiongetForeignType_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customernamecustomerid')
var descforeignType = column.getDescription().getForeignType()
if (foreignType != null)
{
	var fkTable = databaseManager.getTable('example_data', foreignType)
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getForeignTypegetLength|class=node}{tr:id=name}{td}h6.getForeignTypegetLength{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[StringNumber]{span}{span:id=iets|style=float: left; font-weight: bold;}getForeignTypegetLength{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getForeignTypegetLength_des|text=|trigger=button}{sub-section}{sub-section:getForeignTypegetLength_des|trigger=none|class=sIndent}Get the foreignlength type of the column.
The foreign type can be defined design time as a foreign keyreported referenceby tothe anotherJDBC tabledriver.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getForeignTypegetLength_snc|text=|trigger=button}{sub-section}{sub-section:getForeignTypegetLength_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getForeignTypegetLength_prs|text=|trigger=button}{sub-section}{sub-section:getForeignTypegetLength_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getForeignTypegetLength_ret|text=|trigger=button}{sub-section}{sub-section:getForeignTypegetLength_ret|trigger=none|class=sIndent}[StringNumber] -- Stringint foreigncolumn typelength.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getForeignTypegetLength_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getForeignTypegetLength_see|trigger=none}[databaseManager.mergeRecords|Database Manager#mergeRecords]\\ {sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getForeignTypegetLength_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getForeignTypegetLength_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getForeignTypegetLength_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getForeignTypegetLength_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customeridcustomername')
var foreignType = if (column.getForeignTypegetLength() if (foreignType != null< 10)
{
	var fkTable// = databaseManager.getTable('example_data', foreignType)handle short column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getLengthgetQualifiedName|class=node}{tr:id=name}{td}h6.getLengthgetQualifiedName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[NumberString]{span}{span:id=iets|style=float: left; font-weight: bold;}getLengthgetQualifiedName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getLengthgetQualifiedName_des|text=|trigger=button}{sub-section}{sub-section:getLengthgetQualifiedName_des|trigger=none|class=sIndent}Get the qualified name (including table name) of the column as known by the length of the columndatabase.
The name is quoted, if necessary, as reporteddefined by the JDBCactual database driverused.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getLengthgetQualifiedName_snc|text=|trigger=button}{sub-section}{sub-section:getLengthgetQualifiedName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getLengthgetQualifiedName_prs|text=|trigger=button}{sub-section}{sub-section:getLengthgetQualifiedName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getLengthgetQualifiedName_ret|text=|trigger=button}{sub-section}{sub-section:getLengthgetQualifiedName_ret|trigger=none|class=sIndent}[NumberString] -- intString qualified column lengthname.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getLengthgetQualifiedName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getLengthgetQualifiedName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getLengthgetQualifiedName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getLengthgetQualifiedName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getLengthgetQualifiedName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getLengthgetQualifiedName_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customernamecustomerid')
var qualifiedSqlName if= (column.getLengthgetQualifiedName() < 10)
{
	 // handle
short column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getQualifiedNamegetQuotedSQLName|class=node}{tr:id=name}{td}h6.getQualifiedNamegetQuotedSQLName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getQualifiedNamegetQuotedSQLName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getQualifiedNamegetQuotedSQLName_des|text=|trigger=button}{sub-section}{sub-section:getQualifiedNamegetQuotedSQLName_des|trigger=none|class=sIndent}GetReturns thea qualified name (including table name) quoted version of the column as known by the database.
The name is quoted, if necessary, as defined by the actual database used.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getQualifiedNamegetQuotedSQLName_snc|text=|trigger=button}{sub-section}{sub-section:getQualifiedNamegetQuotedSQLName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getQualifiedNamegetQuotedSQLName_prs|text=|trigger=button}{sub-section}{sub-section:getQualifiedNamegetQuotedSQLName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getQualifiedNamegetQuotedSQLName_ret|text=|trigger=button}{sub-section}{sub-section:getQualifiedNamegetQuotedSQLName_ret|trigger=none|class=sIndent}[String] -- column Stringname, qualifiedquoted columnif nameneeded.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getQualifiedNamegetQuotedSQLName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQualifiedNamegetQuotedSQLName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getQualifiedNamegetQuotedSQLName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQualifiedNamegetQuotedSQLName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getQualifiedNamegetQuotedSQLName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQualifiedNamegetQuotedSQLName_sam|trigger=none}{code:language=javascript}
//use with the raw SQL plugin:
//if the table name contains characters that are illegal in sql, the table name will be quoted
var tablejsTable = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var qualifiedSqlName = column.getQualifiedName(.getTable('udm', 'campaigns')
var quotedTableName = jsTable.getQuotedSQLName()
var jsColumn = jsTable.getColumn('active')
var quotedColumnName = jsColumn.getQuotedSQLName()
plugins.rawSQL.executeSQL('udm',  quotedTableName,  'select * from ' + quotedTableName + ' where ' + quotedColumnName + ' = ?', [1])
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getQuotedSQLNamegetRowIdentifierType|class=node}{tr:id=name}{td}h6.getQuotedSQLNamegetRowIdentifierType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[StringNumber]{span}{span:id=iets|style=float: left; font-weight: bold;}getQuotedSQLNamegetRowIdentifierType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getQuotedSQLNamegetRowIdentifierType_des|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLNamegetRowIdentifierType_des|trigger=none|class=sIndent}ReturnsGet the arow quotedidentifier versiontype of the column name, if necessary, as defined by the actual database used..
The sequence type is one of:
 \- JSColumn.PK\_COLUMN
 \- JSColumn.ROWID\_COLUMN
 \- JSColumn.NONE{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getQuotedSQLNamegetRowIdentifierType_snc|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLNamegetRowIdentifierType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getQuotedSQLNamegetRowIdentifierType_prs|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLNamegetRowIdentifierType_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getQuotedSQLNamegetRowIdentifierType_ret|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLNamegetRowIdentifierType_ret|trigger=none|class=sIndent}[StringNumber] -- columnint name, quoted if neededrow identifier type.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getQuotedSQLNamegetRowIdentifierType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQuotedSQLNamegetRowIdentifierType_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getQuotedSQLNamegetRowIdentifierType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQuotedSQLNamegetRowIdentifierType_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getQuotedSQLNamegetRowIdentifierType_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQuotedSQLNamegetRowIdentifierType_sam|trigger=none}{code:language=javascript}
//usevar withtable the raw SQL plugin:
//if the table name contains characters that are illegal in sql, the table name will be quoted
var jsTable = databaseManager.getTable('udm', 'campaigns')
var quotedTableName = jsTable.getQuotedSQLName()
var jsColumn = jsTable.getColumn('active')
var quotedColumnName = jsColumn.getQuotedSQLName()
plugins.rawSQL.executeSQL('udm',  quotedTableName,  'select * from ' + quotedTableName + ' where ' + quotedColumnName + ' = ?', [1])= databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getRowIdentifierType())
{
case JSColumn.NONE:
	// handle normal column
break;

case JSColumn.PK_COLUMN:
	// handle database pk column
break;

case JSColumn.ROWID_COLUMN:
	// handle developer defined pk column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSQLName|class=node}{tr:id=name}{td}h6.getSQLName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getSQLName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getSQLName_des|text=|trigger=button}{sub-section}{sub-section:getSQLName_des|trigger=none|class=sIndent}Get the name of the column as known by the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSQLName_snc|text=|trigger=button}{sub-section}{sub-section:getSQLName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getSQLName_prs|text=|trigger=button}{sub-section}{sub-section:getSQLName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSQLName_ret|text=|trigger=button}{sub-section}{sub-section:getSQLName_ret|trigger=none|class=sIndent}[String] -- String sql name{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSQLName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getSQLName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSQLName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getSQLName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSQLName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getSQLName_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
var sqlName = column.getSQLName()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getScale|class=node}{tr:id=name}{td}h6.getScale{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getScale{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getScale_des|text=|trigger=button}{sub-section}{sub-section:getScale_des|trigger=none|class=sIndent}Get the scale of the column as reported by the JDBC driver.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getScale_snc|text=|trigger=button}{sub-section}{sub-section:getScale_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getScale_prs|text=|trigger=button}{sub-section}{sub-section:getScale_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getScale_ret|text=|trigger=button}{sub-section}{sub-section:getScale_ret|trigger=none|class=sIndent}[Number] -- int column scale.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getScale_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getScale_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getScale_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getScale_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getScale_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getScale_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customername')
var scale = column.getScale()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTitlegetSequenceType|class=node}{tr:id=name}{td}h6.getTitlegetSequenceType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[StringNumber]{span}{span:id=iets|style=float: left; font-weight: bold;}getTitlegetSequenceType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getTitlegetSequenceType_des|text=|trigger=button}{sub-section}{sub-section:getTitle_des|trigger=none|class=sIndent}Get the title property of the column.}{sub-section}{sub-section:getSequenceType_des|trigger=none|class=sIndent}Get 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;{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getTitlegetSequenceType_snc|text=|trigger=button}{sub-section}{sub-section:getTitlegetSequenceType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getTitlegetSequenceType_prs|text=|trigger=button}{sub-section}{sub-section:getTitlegetSequenceType_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getTitlegetSequenceType_ret|text=|trigger=button}{sub-section}{sub-section:getTitlegetSequenceType_ret|trigger=none|class=sIndent}[StringNumber] -- Stringint columnsequence titletype.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getTitlegetSequenceType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTitlegetSequenceType_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getTitlegetSequenceType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTitlegetSequenceType_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTitlegetSequenceType_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTitlegetSequenceType_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', 'orders')
var column = table.getColumn('customername')
var title = column.getTitle()/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTypegetTitle|class=node}{tr:id=name}{td}h6.getTypegetTitle{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[NumberString]{span}{span:id=iets|style=float: left; font-weight: bold;}getTypegetTitle{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getTypegetTitle_des|text=|trigger=button}{sub-section}{sub-section:getTypegetTitle_des|trigger=none|class=sIndent}Get the JDBCtitle typeproperty 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.MEDIA{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getTypegetTitle_snc|text=|trigger=button}{sub-section}{sub-section:getTypegetTitle_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getTypegetTitle_prs|text=|trigger=button}{sub-section}{sub-section:getTypegetTitle_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getTypegetTitle_ret|text=|trigger=button}{sub-section}{sub-section:getTypegetTitle_ret|trigger=none|class=sIndent}[NumberString] -- intString sqlcolumn typetitle.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getTypegetTitle_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypegetTitle_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getTypegetTitle_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypegetTitle_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTypegetTitle_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypegetTitle_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customeridcustomername')
var switchtitle = (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
getTitle()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTypeAsStringgetType|class=node}{tr:id=name}{td}h6.getTypeAsStringgetType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[StringNumber]{span}{span:id=iets|style=float: left; font-weight: bold;}getTypeAsStringgetType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getTypeAsStringgetType_des|text=|trigger=button}{sub-section}{sub-section:getTypeAsStringgetType_des|trigger=none|class=sIndent}Get the name JDBC type of the column.
The same mapping as defined in JSColumn.getType() is applied.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.MEDIA{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getTypeAsStringgetType_snc|text=|trigger=button}{sub-section}{sub-section:getTypeAsStringgetType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getTypeAsStringgetType_prs|text=|trigger=button}{sub-section}{sub-section:getTypeAsStringgetType_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getTypeAsStringgetType_ret|text=|trigger=button}{sub-section}{sub-section:getTypeAsStringgetType_ret|trigger=none|class=sIndent}[StringNumber] -- Stringint sql nametype.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getTypeAsStringgetType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypeAsStringgetType_see|trigger=none}[.getType|JSColumn#getType]\\ {sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getTypeAsStringgetType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypeAsStringgetType_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTypeAsStringgetType_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypeAsStringgetType_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('customerid')
switch (column.getType()
var typeName = column.getTypeAsString())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isRowIdentifiergetTypeAsString|class=node}{tr:id=name}{td}h6.isRowIdentifiergetTypeAsString{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[BooleanString]{span}{span:id=iets|style=float: left; font-weight: bold;}isRowIdentifiergetTypeAsString{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:isRowIdentifiergetTypeAsString_des|text=|trigger=button}{sub-section}{sub-section:isRowIdentifiergetTypeAsString_des|trigger=none|class=sIndent}IsGet the thisname columnJDBC onetype of the row identifiers for its table column.
The same mapping as defined in JSColumn.getType() is applied.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isRowIdentifiergetTypeAsString_snc|text=|trigger=button}{sub-section}{sub-section:isRowIdentifiergetTypeAsString_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:isRowIdentifiergetTypeAsString_prs|text=|trigger=button}{sub-section}{sub-section:isRowIdentifiergetTypeAsString_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isRowIdentifiergetTypeAsString_ret|text=|trigger=button}{sub-section}{sub-section:isRowIdentifiergetTypeAsString_ret|trigger=none|class=sIndent}[BooleanString] -- booleanString true if is row identifier else falsesql name.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isRowIdentifiergetTypeAsString_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isRowIdentifiergetTypeAsString_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isRowIdentifiergetTypeAsString_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isRowIdentifiergetTypeAsString_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isRowIdentifiergetTypeAsString_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isRowIdentifiergetTypeAsString_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('orderidcustomerid')
ifvar typeName = (column.isRowIdentifiergetTypeAsString())
{
	 //
handle pk column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isUUIDhasFlag|class=node}{tr:id=name}{td}h6.isUUIDhasFlag{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isUUIDhasFlag{span}{span:id=iets|style=float: left;}\(flag){span}{td}{tr}{tr:id=des}{td}{sub-section:isUUIDhasFlag_des|text=|trigger=button}{sub-section}{sub-section:isUUIDhasFlag_des|trigger=none|class=sIndent}Is this column marked as UUID column.sIndent}Check 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\_COLUMN{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isUUIDhasFlag_snc|text=|trigger=button}{sub-section}{sub-section:isUUIDhasFlag_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:isUUIDhasFlag_prs|text=|trigger=button}{sub-section}{sub-section:isUUIDhasFlag_prs|trigger=none|class=sIndent}\{[Number]} flag
{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isUUIDhasFlag_ret|text=|trigger=button}{sub-section}{sub-section:isUUIDhasFlag_ret|trigger=none|class=sIndent}[Boolean] -- boolean truewhether ifflag is marked as UUID columns else falseset.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isUUIDhasFlag_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isUUIDhasFlag_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isUUIDhasFlag_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isUUIDhasFlag_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isUUIDhasFlag_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isUUIDhasFlag_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('db:/example_data', '/orders')
var column = table.getColumn('orderidcustomerid')
if (column.isUUIDhasFlag(JSColumn.UUID_COLUMN))
{
	 // handle UUIDuuid column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 10

New Version 11

Key
