java显示数据库的信息,Java SE 示例：显示数据库模式信息

Metadata options:

Option[ date_format ] = 'YYYY-MM-DD'

Option[ date_order ] = 'YMD'

Option[ global_database_id ] = '0'

Option[ nearest_century ] = '50'

Option[ precision ] = '30'

Option[ scale ] = '6'

Option[ time_format ] = 'HH:NN:SS.SSS'

Option[ timestamp_format ] = 'YYYY-MM-DD HH:NN:SS.SSS'

Option[ timestamp_increment ] = '1'

Metadata tables:

Table[0] name = "systable" id = 0 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "table_name" flags = 0x0 domain = VARCHAR(128)

column[2 ]: name = "table_flags" flags = 0x0 domain = UNSIGNED-SHORT

column[3 ]: name = "table_data" flags = 0x0 domain = INTEGER

column[4 ]: name = "table_autoinc" flags = 0x0 domain = BIG

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "table_id" flags = 0x1,FORWARD

Table[1] name = "syscolumn" id = 1 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "column_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[2 ]: name = "column_name" flags = 0x0 domain = VARCHAR(128)

column[3 ]: name = "column_flags" flags = 0x0 domain = TINY

column[4 ]: name = "column_domain" flags = 0x0 domain = TINY

column[5 ]: name = "column_length" flags = 0x0 domain = INTEGER

column[6 ]: name = "column_default" flags = 0x0 domain = TINY

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "table_id" flags = 0x1,FORWARD

key[1 ]: name = "column_id" flags = 0x1,FORWARD

Table[2] name = "sysindex" id = 2 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "index_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[2 ]: name = "index_name" flags = 0x0 domain = VARCHAR(128)

column[3 ]: name = "index_flags" flags = 0x0 domain = TINY

column[4 ]: name = "index_data" flags = 0x0 domain = INTEGER

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "table_id" flags = 0x1,FORWARD

key[1 ]: name = "index_id" flags = 0x1,FORWARD

Table[3] name = "sysindexcolumn" id = 3 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "index_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[2 ]: name = "order" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[3 ]: name = "column_id" flags = 0x0 domain = INTEGER

column[4 ]: name = "index_column_flags" flags = 0x0 domain = TINY

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "table_id" flags = 0x1,FORWARD

key[1 ]: name = "index_id" flags = 0x1,FORWARD

key[2 ]: name = "order" flags = 0x1,FORWARD

Table[4] name = "sysinternal" id = 4 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "name" flags = 0x1,IN-PRIMARY-INDEX domain = VARCHAR(128)

column[1 ]: name = "value" flags = 0x0 domain = VARCHAR(128)

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "name" flags = 0x1,FORWARD

Table[5] name = "syspublications" id = 5 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "publication_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "publication_name" flags = 0x0 domain = VARCHAR(128)

column[2 ]: name = "download_timestamp" flags = 0x0 domain = TIMESTAMP

column[3 ]: name = "last_sync_sent" flags = 0x0 domain = INTEGER

column[4 ]: name = "last_sync_confirmed" flags = 0x0 domain = INTEGER

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "publication_id" flags = 0x1,FORWARD

Table[6] name = "sysarticles" id = 6 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "publication_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "publication_id" flags = 0x1,FORWARD

key[1 ]: name = "table_id" flags = 0x1,FORWARD

Table[7] name = "sysforeignkey" id = 7 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "foreign_table_id" flags = 0x0 domain = INTEGER

column[2 ]: name = "foreign_key_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[3 ]: name = "name" flags = 0x0 domain = VARCHAR(128)

column[4 ]: name = "index_name" flags = 0x0 domain = VARCHAR(128)

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "table_id" flags = 0x1,FORWARD

key[1 ]: name = "foreign_key_id" flags = 0x1,FORWARD

Table[8] name = "sysfkcol" id = 8 flags = 0xc000,SYSTEM,NO_SYNC

column[0 ]: name = "table_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[1 ]: name = "foreign_key_id" flags = 0x1,IN-PRIMARY-INDEX domain = INTEGER

column[2 ]: name = "item_no" flags = 0x1,IN-PRIMARY-INDEX domain = SHORT

column[3 ]: name = "column_id" flags = 0x0 domain = INTEGER

column[4 ]: name = "foreign_column_id" flags = 0x0 domain = INTEGER

index[0 ]: name = "primary" flags = 0xf,UNIQUE-KEY,UNIQUE-INDEX,PERSISTENT,PRIMARY-INDEX

key[0 ]: name = "table_id" flags = 0x1,FORWARD

key[1 ]: name = "foreign_key_id" flags = 0x1,FORWARD

key[2 ]: name = "item_no" flags = 0x1,FORWARD