LeanXcale Documentation :: LeanXcale Documentation

Create a Table with Array Columns

With LeanXcale, creating a table with array columns is straightforward. You can define an array column in your create table statement using the array data type, allowing you to store collections of values in a single column.

String createTable = "CREATE TABLE tarry (" +
	"id INT, " +
	"longs BIGINT ARRAY, " +
	"doubles DOUBLE ARRAY, " +
	"strings VARCHAR ARRAY, " +
	"PRIMARY KEY(id))";
try (Statement st = conn.createStatement()) {
	st.execute(createTable);
}