Specifies the schema of a column.

Syntax

public ColumnSchema

Remarks

An object supporting this interface is returned by the TableSchema.createColumn(String.short), TableSchema.createColumn(String,short,int) and TableSchema.createColumn(String,short,int,int) methods.

The following example demonstrates the creation of the schema for a simple database. The T1 table is created with a primary key integer column which is auto-incrementing.

// Assumes a valid Connection object
TableSchema table_schema;
ColumnSchema col_schema;
IndexSchema index_schema;

table_schema = conn.createTable("T1");
col_schema = table_schema.createColumn("num", Domain.INTEGER);
col_schema.setDefault(ColumnSchema.COLUMN_DEFAULT_AUTOINC);

// BIT columns are not nullable by default.
col_schema = table_schema.createColumn("flag", Domain.BIT);
col_schema.setNullable(true);
col_schema = table_schema.createColumn(
    "cost", Domain.NUMERIC, 10, 2
    );
col_schema.setNullable(false);

index_schema = table_schema.createPrimaryIndex("primary");
index_schema.addColumn("num", IndexSchema.ASCENDING);
conn.schemaCreateComplete();

Members

All members of ColumnSchema, including all inherited members.

• COLUMN_DEFAULT_AUTOINC variable
• COLUMN_DEFAULT_CURRENT_DATE variable
• COLUMN_DEFAULT_CURRENT_TIME variable
• COLUMN_DEFAULT_CURRENT_TIMESTAMP variable
• COLUMN_DEFAULT_GLOBAL_AUTOINC variable
• COLUMN_DEFAULT_NONE variable
• COLUMN_DEFAULT_UNIQUE_ID variable
• setDefault function
• setNullable function