create table t1 (id int primary key, c1 int default 1) engine=xengine; alter table t1 add column c2 int default 2, add column c3 char(100) default "c3c3c3c3c3c3", add column c4 varchar(100) default "c4c4c4c4c4c4c4c4c4", add column c5 double default 5.5, add column c6 blob, add column c7 text; select * from information_schema.XENGINE_TABLES; SCHEMA_NAME NAME N_COLS INSTANT_COLS test t1 8 2 select * from information_schema.XENGINE_COLUMNS; NAME SCHEMA_NAME TABLE_NAME IS_INSTANTLY_ADDED HAS_ORIGINAL_DEFAULT ORIGIN_DEFAULT_VALUE id test t1 0 0 NULL c1 test t1 0 0 NULL c2 test t1 1 1 02000000 c3 test t1 1 1 63336333633363336333633320202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 c4 test t1 1 1 120063346334633463346334633463346334633400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 c5 test t1 1 1 0000000000001640 c6 test t1 1 0 NULL c7 test t1 1 0 NULL drop table t1;