com.aquafold.openapi.rdbms.schema
Interface AQTableColumn

All Superinterfaces:

AQSchemaObject, AQServerObject

public interface AQTableColumn
extends AQSchemaObject

This interface represents a table column.

Method Summary

String	getDataType() To get the data type associated with the column.
Object	getDefaultValue() To the string representation of the default value for the column.
String	getJavaType() Returns fully qualified name of the java type associated with the column.
int	getLength() To get the maximum length of string columns.
int	getPrecision() To get the precision for numeric columns.
int	getScale() To get the scale for numeric columns.
int	getSqlType() Returns an integer representing the SQL type associated with the column.
boolean	isEditable() Returns true or false depending on whether the column is editable.
boolean	isIdentity() To get information on whether the column is an identity column.
boolean	isNullable() To get information on whether the column is nullable.

Methods inherited from interface com.aquafold.openapi.rdbms.AQSchemaObject

getDatabaseName, getSchemaName

Methods inherited from interface com.aquafold.openapi.rdbms.AQServerObject

getIcon, getName, getServerConnection, getTypeName, scriptCREATE, scriptCREATE, scriptDROP

Method Detail

getDataType

String getDataType()

To get the data type associated with the column.

Returns:

The name of the data type.

getJavaType

String getJavaType()

Returns fully qualified name of the java type associated with the column.

isIdentity

boolean isIdentity()

To get information on whether the column is an identity column.

Returns:

A boolean value; true if it's an identity column, false if it's not.

isNullable

boolean isNullable()

To get information on whether the column is nullable.

Returns:

A boolean value; true if it's nullable, false if it's not.

getDefaultValue

Object getDefaultValue()

To the string representation of the default value for the column.

Returns:

The default value as a string; empty string if there are no default value for the column.

getPrecision

int getPrecision()

To get the precision for numeric columns.

Returns:

The precision for this column.

getScale

int getScale()

To get the scale for numeric columns.

Returns:

The scale for this column.

getLength

int getLength()

To get the maximum length of string columns. Example

CREATE	TABLE (
	x varchar(25)
)

The maximum length would be 25.

Returns:

The length of this column.

getSqlType

int getSqlType()

Returns an integer representing the SQL type associated with the column. Types

isEditable

boolean isEditable()

Returns true or false depending on whether the column is editable.