{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:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#DATETIME]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#INTEGER]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#MEDIA]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#NUMBER]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#TEXT]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{table}\\ 

{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[Boolean]{td}{td}[#getAllowNull]\()
Get the allow-null flag of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getDataProviderID]\()
Get the data provider id (name) for this column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getDescription]\()
Get the description property of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getForeignType]\()
Get the foreign type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getLength]\()
Get the length of the column as reported by the 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}[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}[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}[#isRowIdentifier]\()
Is this column one of the row identifiers for its table.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isUUID]\()
Is this column marked as UUID column.{td}{tr}{tbody}{table}\\ 

{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_des|text=|trigger=button}{sub-section}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_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=prs}{td}*Parameters*\\{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_ret|text=|trigger=button}{sub-section}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_see|text=|trigger=button}{sub-section}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_see|text=|trigger=button}{sub-section}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_sam|text=|trigger=button}{sub-section}{sub-section:E9B9C95C-4CE8-4EAB-842A-3DF0EC722E9A_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_des|text=|trigger=button}{sub-section}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_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=prs}{td}*Parameters*\\{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_ret|text=|trigger=button}{sub-section}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_see|text=|trigger=button}{sub-section}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_see|text=|trigger=button}{sub-section}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_sam|text=|trigger=button}{sub-section}{sub-section:F209C3DD-FCD7-4A4D-84F0-2E2BFA1232B9_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_des|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_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=prs}{td}*Parameters*\\{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_ret|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_see|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_see|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_sam|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE-6C56-4F36-9CE7-EEBD35DBF841_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=87049E2D-8665-404E-8E3C-9F171BD81CAD}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_des|text=|trigger=button}{sub-section}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_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=prs}{td}*Parameters*\\{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_ret|text=|trigger=button}{sub-section}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_see|text=|trigger=button}{sub-section}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_see|text=|trigger=button}{sub-section}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_sam|text=|trigger=button}{sub-section}{sub-section:87049E2D-8665-404E-8E3C-9F171BD81CAD_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=3F6A422B-816C-40F6-BEA5-659B00195207}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_des|text=|trigger=button}{sub-section}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_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=prs}{td}*Parameters*\\{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_ret|text=|trigger=button}{sub-section}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_see|text=|trigger=button}{sub-section}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_see|text=|trigger=button}{sub-section}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_sam|text=|trigger=button}{sub-section}{sub-section:3F6A422B-816C-40F6-BEA5-659B00195207_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=787195ED-1C03-464C-811F-CC89EE1CBA65}{tr:id=name}{td}h6.getAllowNull{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}getAllowNull{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_des|text=|trigger=button}{sub-section}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_des|trigger=none|class=sIndent}Get the allow-null flag of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_ret|text=|trigger=button}{sub-section}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_ret|trigger=none|class=sIndent}[Boolean] -- boolean allow-null flag.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_see|text=|trigger=button}{sub-section}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_see|text=|trigger=button}{sub-section}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_sam|text=|trigger=button}{sub-section}{sub-section:787195ED-1C03-464C-811F-CC89EE1CBA65_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
if (!column.getAllowNull())
{
	 // column cannot be null
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=87674324-96D7-4D56-AE37-E27E5BBAA711}{tr:id=name}{td}h6.getDataProviderID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDataProviderID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_des|text=|trigger=button}{sub-section}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_des|trigger=none|class=sIndent}Get the data provider id (name) for this column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_ret|text=|trigger=button}{sub-section}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_ret|trigger=none|class=sIndent}[String] -- String dataprovider id.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_see|text=|trigger=button}{sub-section}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_see|text=|trigger=button}{sub-section}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_sam|text=|trigger=button}{sub-section}{sub-section:87674324-96D7-4D56-AE37-E27E5BBAA711_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var dataProviderId = column.getDataProviderID()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=86135BCF-2A0F-4260-87AF-5DB5353A1EDF}{tr:id=name}{td}h6.getDescription{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDescription{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_des|text=|trigger=button}{sub-section}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_des|trigger=none|class=sIndent}Get the description property of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_ret|text=|trigger=button}{sub-section}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_ret|trigger=none|class=sIndent}[String] -- String column description.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_see|text=|trigger=button}{sub-section}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_see|text=|trigger=button}{sub-section}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_sam|text=|trigger=button}{sub-section}{sub-section:86135BCF-2A0F-4260-87AF-5DB5353A1EDF_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var desc = column.getDescription()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF}{tr:id=name}{td}h6.getForeignType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getForeignType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_des|text=|trigger=button}{sub-section}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_des|trigger=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=prs}{td}*Parameters*\\{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_ret|text=|trigger=button}{sub-section}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_ret|trigger=none|class=sIndent}[String] -- String foreign type.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_see|text=|trigger=button}{sub-section}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_see|class=sIndent|trigger=none}[databaseManager.mergeRecords|Database Manager#mergeRecords]\\{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_see|text=|trigger=button}{sub-section}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_sam|text=|trigger=button}{sub-section}{sub-section:C9DC2C5A-F032-4E01-AAEA-B84A37FE0CCF_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var foreignType = column.getForeignType()
if (foreignType != null)
{
	var fkTable = databaseManager.getTable('example_data', foreignType)
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=02AE4C58-24A8-4975-A0CA-971F6479AC19}{tr:id=name}{td}h6.getLength{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getLength{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_des|text=|trigger=button}{sub-section}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_des|trigger=none|class=sIndent}Get the length of the column as reported by the JDBC driver.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_ret|text=|trigger=button}{sub-section}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_ret|trigger=none|class=sIndent}[Number] -- int column length.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_see|text=|trigger=button}{sub-section}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_see|text=|trigger=button}{sub-section}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_sam|text=|trigger=button}{sub-section}{sub-section:02AE4C58-24A8-4975-A0CA-971F6479AC19_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
if (column.getLength() < 10)
{
	 // handle short column
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=821DB8B6-1BED-433F-A596-2605C58D9302}{tr:id=name}{td}h6.getQualifiedName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getQualifiedName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_des|text=|trigger=button}{sub-section}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_des|trigger=none|class=sIndent}Get 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.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_ret|text=|trigger=button}{sub-section}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_ret|trigger=none|class=sIndent}[String] -- String qualified column name.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_see|text=|trigger=button}{sub-section}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_see|text=|trigger=button}{sub-section}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_sam|text=|trigger=button}{sub-section}{sub-section:821DB8B6-1BED-433F-A596-2605C58D9302_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var qualifiedSqlName = column.getQualifiedName()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D}{tr:id=name}{td}h6.getQuotedSQLName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getQuotedSQLName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_des|text=|trigger=button}{sub-section}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_des|trigger=none|class=sIndent}Returns a quoted version of the column name, if necessary, as defined by the actual database used.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_ret|text=|trigger=button}{sub-section}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_ret|trigger=none|class=sIndent}[String] -- column name, quoted if needed.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_see|text=|trigger=button}{sub-section}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_see|text=|trigger=button}{sub-section}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_sam|text=|trigger=button}{sub-section}{sub-section:AA7BD5CD-3EE5-479F-B6D8-FCA31E5C266D_sam|class=sIndent|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 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])
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=3A0F019E-1D3A-4B65-8562-9354A8AE4A0C}{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:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_des|text=|trigger=button}{sub-section}{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_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=prs}{td}*Parameters*\\{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_ret|text=|trigger=button}{sub-section}{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_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:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_see|text=|trigger=button}{sub-section}{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_see|text=|trigger=button}{sub-section}{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_sam|text=|trigger=button}{sub-section}{sub-section:3A0F019E-1D3A-4B65-8562-9354A8AE4A0C_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var sqlName = column.getSQLName()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=0317D23B-6419-4428-A54C-0748D5653246}{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:0317D23B-6419-4428-A54C-0748D5653246_des|text=|trigger=button}{sub-section}{sub-section:0317D23B-6419-4428-A54C-0748D5653246_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=prs}{td}*Parameters*\\{sub-section:0317D23B-6419-4428-A54C-0748D5653246_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0317D23B-6419-4428-A54C-0748D5653246_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0317D23B-6419-4428-A54C-0748D5653246_ret|text=|trigger=button}{sub-section}{sub-section:0317D23B-6419-4428-A54C-0748D5653246_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:0317D23B-6419-4428-A54C-0748D5653246_see|text=|trigger=button}{sub-section}{sub-section:0317D23B-6419-4428-A54C-0748D5653246_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0317D23B-6419-4428-A54C-0748D5653246_see|text=|trigger=button}{sub-section}{sub-section:0317D23B-6419-4428-A54C-0748D5653246_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0317D23B-6419-4428-A54C-0748D5653246_sam|text=|trigger=button}{sub-section}{sub-section:0317D23B-6419-4428-A54C-0748D5653246_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var scale = column.getScale()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=E989115E-5986-4A0B-80AD-6CA049A5B2A7}{tr:id=name}{td}h6.getTitle{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getTitle{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_des|text=|trigger=button}{sub-section}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_des|trigger=none|class=sIndent}Get the title property of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_ret|text=|trigger=button}{sub-section}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_ret|trigger=none|class=sIndent}[String] -- String column title.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_see|text=|trigger=button}{sub-section}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_see|text=|trigger=button}{sub-section}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_sam|text=|trigger=button}{sub-section}{sub-section:E989115E-5986-4A0B-80AD-6CA049A5B2A7_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var title = column.getTitle()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=0EEA096E-D6F6-4A10-AC87-2FF58830B10B}{tr:id=name}{td}h6.getType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_des|text=|trigger=button}{sub-section}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_des|trigger=none|class=sIndent}Get 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.MEDIA{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_ret|text=|trigger=button}{sub-section}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_ret|trigger=none|class=sIndent}[Number] -- int sql type.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_see|text=|trigger=button}{sub-section}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_see|text=|trigger=button}{sub-section}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_sam|text=|trigger=button}{sub-section}{sub-section:0EEA096E-D6F6-4A10-AC87-2FF58830B10B_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=7C649E86-8198-41BD-8470-248C954C613B}{tr:id=name}{td}h6.getTypeAsString{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getTypeAsString{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_des|text=|trigger=button}{sub-section}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_des|trigger=none|class=sIndent}Get the name JDBC type of the column.
The same mapping as defined in JSColumn.getType() is applied.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:7C649E86-8198-41BD-8470-248C954C613B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:7C649E86-8198-41BD-8470-248C954C613B_ret|text=|trigger=button}{sub-section}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_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:7C649E86-8198-41BD-8470-248C954C613B_see|text=|trigger=button}{sub-section}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_see|class=sIndent|trigger=none}[.getType|JSColumn#getType]\\{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:7C649E86-8198-41BD-8470-248C954C613B_see|text=|trigger=button}{sub-section}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:7C649E86-8198-41BD-8470-248C954C613B_sam|text=|trigger=button}{sub-section}{sub-section:7C649E86-8198-41BD-8470-248C954C613B_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var typeName = column.getTypeAsString()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=49355F4B-AD0B-49D6-AF05-54BDF9706F0A}{tr:id=name}{td}h6.isRowIdentifier{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isRowIdentifier{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_des|text=|trigger=button}{sub-section}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_des|trigger=none|class=sIndent}Is this column one of the row identifiers for its table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_ret|text=|trigger=button}{sub-section}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if is row identifier else false.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_see|text=|trigger=button}{sub-section}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_see|text=|trigger=button}{sub-section}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_sam|text=|trigger=button}{sub-section}{sub-section:49355F4B-AD0B-49D6-AF05-54BDF9706F0A_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isRowIdentifier())
{
	 // handle pk column
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=AFD330F9-BDC9-47FA-975E-E8A74E36281B}{tr:id=name}{td}h6.isUUID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isUUID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_des|text=|trigger=button}{sub-section}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_des|trigger=none|class=sIndent}Is this column marked as UUID column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_ret|text=|trigger=button}{sub-section}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if is marked as UUID columns else false.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_see|text=|trigger=button}{sub-section}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_see|text=|trigger=button}{sub-section}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_sam|text=|trigger=button}{sub-section}{sub-section:AFD330F9-BDC9-47FA-975E-E8A74E36281B_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isUUID())
{
	 // handle UUID column
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}