大奖游戏djpt8官网,大奖官方网站88tb88

CHARACTER_SETS

ColumnTypeNullDefault Comments
CHARACTER_SET_NAMEvarchar(32)No
DEFAULT_COLLATE_NAMEvarchar(32)No
DESCRIPTIONvarchar(60)No
MAXLENbigint(3)No0

COLLATIONS

ColumnTypeNullDefault Comments
COLLATION_NAMEvarchar(32)No
CHARACTER_SET_NAMEvarchar(32)No
IDbigint(11)No0
IS_DEFAULTvarchar(3)No
IS_COMPILEDvarchar(3)No
SORTLENbigint(3)No0

COLLATION_CHARACTER_SET_APPLICABILITY

ColumnTypeNullDefault Comments
COLLATION_NAMEvarchar(32)No
CHARACTER_SET_NAMEvarchar(32)No

COLUMNS

ColumnTypeNullDefault Comments
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
COLUMN_NAMEvarchar(64)No
ORDINAL_POSITIONbigint(21)No0
COLUMN_DEFAULTlongtextYesNULL
IS_NULLABLEvarchar(3)No
DATA_TYPEvarchar(64)No
CHARACTER_MAXIMUM_LENGTHbigint(21)YesNULL
CHARACTER_OCTET_LENGTHbigint(21)YesNULL
NUMERIC_PRECISIONbigint(21)YesNULL
NUMERIC_SCALEbigint(21)YesNULL
DATETIME_PRECISIONbigint(21)YesNULL
CHARACTER_SET_NAMEvarchar(32)YesNULL
COLLATION_NAMEvarchar(32)YesNULL
COLUMN_TYPElongtextNo
COLUMN_KEYvarchar(3)No
EXTRAvarchar(30)No
PRIVILEGESvarchar(80)No
COLUMN_COMMENTvarchar(1024)No
GENERATION_EXPRESSIONlongtextNo

COLUMN_PRIVILEGES

ColumnTypeNullDefault Comments
GRANTEEvarchar(81)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
COLUMN_NAMEvarchar(64)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

ENGINES

ColumnTypeNullDefault Comments
ENGINEvarchar(64)No
SUPPORTvarchar(8)No
COMMENTvarchar(80)No
TRANSACTIONSvarchar(3)YesNULL
XAvarchar(3)YesNULL
SAVEPOINTSvarchar(3)YesNULL

EVENTS

ColumnTypeNullDefault Comments
EVENT_CATALOGvarchar(64)No
EVENT_SCHEMAvarchar(64)No
EVENT_NAMEvarchar(64)No
DEFINERvarchar(93)No
TIME_ZONEvarchar(64)No
EVENT_BODYvarchar(8)No
EVENT_DEFINITIONlongtextNo
EVENT_TYPEvarchar(9)No
EXECUTE_ATdatetimeYesNULL
INTERVAL_VALUEvarchar(256)YesNULL
INTERVAL_FIELDvarchar(18)YesNULL
SQL_MODEvarchar(8192)No
STARTSdatetimeYesNULL
ENDSdatetimeYesNULL
STATUSvarchar(18)No
ON_COMPLETIONvarchar(12)No
CREATEDdatetimeNo0000-00-00 00:00:00
LAST_ALTEREDdatetimeNo0000-00-00 00:00:00
LAST_EXECUTEDdatetimeYesNULL
EVENT_COMMENTvarchar(64)No
ORIGINATORbigint(10)No0
CHARACTER_SET_CLIENTvarchar(32)No
COLLATION_CONNECTIONvarchar(32)No
DATABASE_COLLATIONvarchar(32)No

FILES

ColumnTypeNullDefault Comments
FILE_IDbigint(4)No0
FILE_NAMEvarchar(4000)YesNULL
FILE_TYPEvarchar(20)No
TABLESPACE_NAMEvarchar(64)YesNULL
TABLE_CATALOGvarchar(64)No
TABLE_SCHEMAvarchar(64)YesNULL
TABLE_NAMEvarchar(64)YesNULL
LOGFILE_GROUP_NAMEvarchar(64)YesNULL
LOGFILE_GROUP_NUMBERbigint(4)YesNULL
ENGINEvarchar(64)No
FULLTEXT_KEYSvarchar(64)YesNULL
DELETED_ROWSbigint(4)YesNULL
UPDATE_COUNTbigint(4)YesNULL
FREE_EXTENTSbigint(4)YesNULL
TOTAL_EXTENTSbigint(4)YesNULL
EXTENT_SIZEbigint(4)No0
INITIAL_SIZEbigint(21)YesNULL
MAXIMUM_SIZEbigint(21)YesNULL
AUTOEXTEND_SIZEbigint(21)YesNULL
CREATION_TIMEdatetimeYesNULL
LAST_UPDATE_TIMEdatetimeYesNULL
LAST_ACCESS_TIMEdatetimeYesNULL
RECOVER_TIMEbigint(4)YesNULL
TRANSACTION_COUNTERbigint(4)YesNULL
VERSIONbigint(21)YesNULL
ROW_FORMATvarchar(10)YesNULL
TABLE_ROWSbigint(21)YesNULL
AVG_ROW_LENGTHbigint(21)YesNULL
DATA_LENGTHbigint(21)YesNULL
MAX_DATA_LENGTHbigint(21)YesNULL
INDEX_LENGTHbigint(21)YesNULL
DATA_FREEbigint(21)YesNULL
CREATE_TIMEdatetimeYesNULL
UPDATE_TIMEdatetimeYesNULL
CHECK_TIMEdatetimeYesNULL
CHECKSUMbigint(21)YesNULL
STATUSvarchar(20)No
EXTRAvarchar(255)YesNULL

GLOBAL_STATUS

ColumnTypeNullDefault Comments
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(1024)YesNULL

GLOBAL_VARIABLES

ColumnTypeNullDefault Comments
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(1024)YesNULL

INNODB_BUFFER_PAGE

ColumnTypeNullDefault Comments
POOL_IDbigint(21)No0
BLOCK_IDbigint(21)No0
SPACEbigint(21)No0
PAGE_NUMBERbigint(21)No0
PAGE_TYPEvarchar(64)YesNULL
FLUSH_TYPEbigint(21)No0
FIX_COUNTbigint(21)No0
IS_HASHEDvarchar(3)YesNULL
NEWEST_MODIFICATIONbigint(21)No0
OLDEST_MODIFICATIONbigint(21)No0
ACCESS_TIMEbigint(21)No0
TABLE_NAMEvarchar(1024)YesNULL
INDEX_NAMEvarchar(1024)YesNULL
NUMBER_RECORDSbigint(21)No0
DATA_SIZEbigint(21)No0
COMPRESSED_SIZEbigint(21)No0
PAGE_STATEvarchar(64)YesNULL
IO_FIXvarchar(64)YesNULL
IS_OLDvarchar(3)YesNULL
FREE_PAGE_CLOCKbigint(21)No0

INNODB_BUFFER_PAGE_LRU

ColumnTypeNullDefault Comments
POOL_IDbigint(21)No0
LRU_POSITIONbigint(21)No0
SPACEbigint(21)No0
PAGE_NUMBERbigint(21)No0
PAGE_TYPEvarchar(64)YesNULL
FLUSH_TYPEbigint(21)No0
FIX_COUNTbigint(21)No0
IS_HASHEDvarchar(3)YesNULL
NEWEST_MODIFICATIONbigint(21)No0
OLDEST_MODIFICATIONbigint(21)No0
ACCESS_TIMEbigint(21)No0
TABLE_NAMEvarchar(1024)YesNULL
INDEX_NAMEvarchar(1024)YesNULL
NUMBER_RECORDSbigint(21)No0
DATA_SIZEbigint(21)No0
COMPRESSED_SIZEbigint(21)No0
COMPRESSEDvarchar(3)YesNULL
IO_FIXvarchar(64)YesNULL
IS_OLDvarchar(3)YesNULL
FREE_PAGE_CLOCKbigint(21)No0

INNODB_BUFFER_POOL_STATS

ColumnTypeNullDefault Comments
POOL_IDbigint(21)No0
POOL_SIZEbigint(21)No0
FREE_BUFFERSbigint(21)No0
DATABASE_PAGESbigint(21)No0
OLD_DATABASE_PAGESbigint(21)No0
MODIFIED_DATABASE_PAGESbigint(21)No0
PENDING_DECOMPRESSbigint(21)No0
PENDING_READSbigint(21)No0
PENDING_FLUSH_LRUbigint(21)No0
PENDING_FLUSH_LISTbigint(21)No0
PAGES_MADE_YOUNGbigint(21)No0
PAGES_NOT_MADE_YOUNGbigint(21)No0
PAGES_MADE_YOUNG_RATEdoubleNo0
PAGES_MADE_NOT_YOUNG_RATEdoubleNo0
NUMBER_PAGES_READbigint(21)No0
NUMBER_PAGES_CREATEDbigint(21)No0
NUMBER_PAGES_WRITTENbigint(21)No0
PAGES_READ_RATEdoubleNo0
PAGES_CREATE_RATEdoubleNo0
PAGES_WRITTEN_RATEdoubleNo0
NUMBER_PAGES_GETbigint(21)No0
HIT_RATEbigint(21)No0
YOUNG_MAKE_PER_THOUSAND_GETSbigint(21)No0
NOT_YOUNG_MAKE_PER_THOUSAND_GETSbigint(21)No0
NUMBER_PAGES_READ_AHEADbigint(21)No0
NUMBER_READ_AHEAD_EVICTEDbigint(21)No0
READ_AHEAD_RATEdoubleNo0
READ_AHEAD_EVICTED_RATEdoubleNo0
LRU_IO_TOTALbigint(21)No0
LRU_IO_CURRENTbigint(21)No0
UNCOMPRESS_TOTALbigint(21)No0
UNCOMPRESS_CURRENTbigint(21)No0

INNODB_CMP

ColumnTypeNullDefault Comments
page_sizeint(5)No0
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_CMPMEM

ColumnTypeNullDefault Comments
page_sizeint(5)No0
buffer_pool_instanceint(11)No0
pages_usedint(11)No0
pages_freeint(11)No0
relocation_opsbigint(21)No0
relocation_timeint(11)No0

INNODB_CMPMEM_RESET

ColumnTypeNullDefault Comments
page_sizeint(5)No0
buffer_pool_instanceint(11)No0
pages_usedint(11)No0
pages_freeint(11)No0
relocation_opsbigint(21)No0
relocation_timeint(11)No0

INNODB_CMP_PER_INDEX

ColumnTypeNullDefault Comments
database_namevarchar(192)No
table_namevarchar(192)No
index_namevarchar(192)No
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_CMP_PER_INDEX_RESET

ColumnTypeNullDefault Comments
database_namevarchar(192)No
table_namevarchar(192)No
index_namevarchar(192)No
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_CMP_RESET

ColumnTypeNullDefault Comments
page_sizeint(5)No0
compress_opsint(11)No0
compress_ops_okint(11)No0
compress_timeint(11)No0
uncompress_opsint(11)No0
uncompress_timeint(11)No0

INNODB_FT_BEING_DELETED

ColumnTypeNullDefault Comments
DOC_IDbigint(21)No0

INNODB_FT_CONFIG

ColumnTypeNullDefault Comments
KEYvarchar(193)No
VALUEvarchar(193)No

INNODB_FT_DEFAULT_STOPWORD

ColumnTypeNullDefault Comments
valuevarchar(18)No

INNODB_FT_DELETED

ColumnTypeNullDefault Comments
DOC_IDbigint(21)No0

INNODB_FT_INDEX_CACHE

ColumnTypeNullDefault Comments
WORDvarchar(337)No
FIRST_DOC_IDbigint(21)No0
LAST_DOC_IDbigint(21)No0
DOC_COUNTbigint(21)No0
DOC_IDbigint(21)No0
POSITIONbigint(21)No0

INNODB_FT_INDEX_TABLE

ColumnTypeNullDefault Comments
WORDvarchar(337)No
FIRST_DOC_IDbigint(21)No0
LAST_DOC_IDbigint(21)No0
DOC_COUNTbigint(21)No0
DOC_IDbigint(21)No0
POSITIONbigint(21)No0

INNODB_LOCKS

ColumnTypeNullDefault Comments
lock_idvarchar(81)No
lock_trx_idvarchar(18)No
lock_modevarchar(32)No
lock_typevarchar(32)No
lock_tablevarchar(1024)No
lock_indexvarchar(1024)YesNULL
lock_spacebigint(21)YesNULL
lock_pagebigint(21)YesNULL
lock_recbigint(21)YesNULL
lock_datavarchar(8192)YesNULL

INNODB_LOCK_WAITS

ColumnTypeNullDefault Comments
requesting_trx_idvarchar(18)No
requested_lock_idvarchar(81)No
blocking_trx_idvarchar(18)No
blocking_lock_idvarchar(81)No

INNODB_METRICS

ColumnTypeNullDefault Comments
NAMEvarchar(193)No
SUBSYSTEMvarchar(193)No
COUNTbigint(21)No0
MAX_COUNTbigint(21)YesNULL
MIN_COUNTbigint(21)YesNULL
AVG_COUNTdoubleYesNULL
COUNT_RESETbigint(21)No0
MAX_COUNT_RESETbigint(21)YesNULL
MIN_COUNT_RESETbigint(21)YesNULL
AVG_COUNT_RESETdoubleYesNULL
TIME_ENABLEDdatetimeYesNULL
TIME_DISABLEDdatetimeYesNULL
TIME_ELAPSEDbigint(21)YesNULL
TIME_RESETdatetimeYesNULL
STATUSvarchar(193)No
TYPEvarchar(193)No
COMMENTvarchar(193)No

INNODB_SYS_COLUMNS

ColumnTypeNullDefault Comments
TABLE_IDbigint(21)No0
NAMEvarchar(193)No
POSbigint(21)No0
MTYPEint(11)No0
PRTYPEint(11)No0
LENint(11)No0

INNODB_SYS_DATAFILES

ColumnTypeNullDefault Comments
SPACEint(11)No0
PATHvarchar(4000)No

INNODB_SYS_FIELDS

ColumnTypeNullDefault Comments
INDEX_IDbigint(21)No0
NAMEvarchar(193)No
POSint(11)No0

INNODB_SYS_FOREIGN

ColumnTypeNullDefault Comments
IDvarchar(193)No
FOR_NAMEvarchar(193)No
REF_NAMEvarchar(193)No
N_COLSint(11)No0
TYPEint(11)No0

INNODB_SYS_FOREIGN_COLS

ColumnTypeNullDefault Comments
IDvarchar(193)No
FOR_COL_NAMEvarchar(193)No
REF_COL_NAMEvarchar(193)No
POSint(11)No0

INNODB_SYS_INDEXES

ColumnTypeNullDefault Comments
INDEX_IDbigint(21)No0
NAMEvarchar(193)No
TABLE_IDbigint(21)No0
TYPEint(11)No0
N_FIELDSint(11)No0
PAGE_NOint(11)No0
SPACEint(11)No0
MERGE_THRESHOLDint(11)No0

INNODB_SYS_TABLES

ColumnTypeNullDefault Comments
TABLE_IDbigint(21)No0
NAMEvarchar(655)No
FLAGint(11)No0
N_COLSint(11)No0
SPACEint(11)No0
FILE_FORMATvarchar(10)YesNULL
ROW_FORMATvarchar(12)YesNULL
ZIP_PAGE_SIZEint(11)No0
SPACE_TYPEvarchar(10)YesNULL

INNODB_SYS_TABLESPACES

ColumnTypeNullDefault Comments
SPACEint(11)No0
NAMEvarchar(655)No
FLAGint(11)No0
FILE_FORMATvarchar(10)YesNULL
ROW_FORMATvarchar(22)YesNULL
PAGE_SIZEint(11)No0
ZIP_PAGE_SIZEint(11)No0
SPACE_TYPEvarchar(10)YesNULL
FS_BLOCK_SIZEint(11)No0
FILE_SIZEbigint(21)No0
ALLOCATED_SIZEbigint(21)No0

INNODB_SYS_TABLESTATS

ColumnTypeNullDefault Comments
TABLE_IDbigint(21)No0
NAMEvarchar(193)No
STATS_INITIALIZEDvarchar(193)No
NUM_ROWSbigint(21)No0
CLUST_INDEX_SIZEbigint(21)No0
OTHER_INDEX_SIZEbigint(21)No0
MODIFIED_COUNTERbigint(21)No0
AUTOINCbigint(21)No0
REF_COUNTint(11)No0

INNODB_SYS_VIRTUAL

ColumnTypeNullDefault Comments
TABLE_IDbigint(21)No0
POSint(11)No0
BASE_POSint(11)No0

INNODB_TEMP_TABLE_INFO

ColumnTypeNullDefault Comments
TABLE_IDbigint(21)No0
NAMEvarchar(202)YesNULL
N_COLSint(11)No0
SPACEint(11)No0
PER_TABLE_TABLESPACEvarchar(64)YesNULL
IS_COMPRESSEDvarchar(64)YesNULL

INNODB_TRX

ColumnTypeNullDefault Comments
trx_idvarchar(18)No
trx_statevarchar(13)No
trx_starteddatetimeNo0000-00-00 00:00:00
trx_requested_lock_idvarchar(81)YesNULL
trx_wait_starteddatetimeYesNULL
trx_weightbigint(21)No0
trx_mysql_thread_idbigint(21)No0
trx_queryvarchar(1024)YesNULL
trx_operation_statevarchar(64)YesNULL
trx_tables_in_usebigint(21)No0
trx_tables_lockedbigint(21)No0
trx_lock_structsbigint(21)No0
trx_lock_memory_bytesbigint(21)No0
trx_rows_lockedbigint(21)No0
trx_rows_modifiedbigint(21)No0
trx_concurrency_ticketsbigint(21)No0
trx_isolation_levelvarchar(16)No
trx_unique_checksint(1)No0
trx_foreign_key_checksint(1)No0
trx_last_foreign_key_errorvarchar(256)YesNULL
trx_adaptive_hash_latchedint(1)No0
trx_adaptive_hash_timeoutbigint(21)No0
trx_is_read_onlyint(1)No0
trx_autocommit_non_lockingint(1)No0

KEY_COLUMN_USAGE

ColumnTypeNullDefault Comments
CONSTRAINT_CATALOGvarchar(512)No
CONSTRAINT_SCHEMAvarchar(64)No
CONSTRAINT_NAMEvarchar(64)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
COLUMN_NAMEvarchar(64)No
ORDINAL_POSITIONbigint(10)No0
POSITION_IN_UNIQUE_CONSTRAINTbigint(10)YesNULL
REFERENCED_TABLE_SCHEMAvarchar(64)YesNULL
REFERENCED_TABLE_NAMEvarchar(64)YesNULL
REFERENCED_COLUMN_NAMEvarchar(64)YesNULL

OPTIMIZER_TRACE

ColumnTypeNullDefault Comments
QUERYlongtextNo
TRACElongtextNo
MISSING_BYTES_BEYOND_MAX_MEM_SIZEint(20)No0
INSUFFICIENT_PRIVILEGEStinyint(1)No0

PARAMETERS

ColumnTypeNullDefault Comments
SPECIFIC_CATALOGvarchar(512)No
SPECIFIC_SCHEMAvarchar(64)No
SPECIFIC_NAMEvarchar(64)No
ORDINAL_POSITIONint(21)No0
PARAMETER_MODEvarchar(5)YesNULL
PARAMETER_NAMEvarchar(64)YesNULL
DATA_TYPEvarchar(64)No
CHARACTER_MAXIMUM_LENGTHint(21)YesNULL
CHARACTER_OCTET_LENGTHint(21)YesNULL
NUMERIC_PRECISIONbigint(21)YesNULL
NUMERIC_SCALEint(21)YesNULL
DATETIME_PRECISIONbigint(21)YesNULL
CHARACTER_SET_NAMEvarchar(64)YesNULL
COLLATION_NAMEvarchar(64)YesNULL
DTD_IDENTIFIERlongtextNo
ROUTINE_TYPEvarchar(9)No

PARTITIONS

ColumnTypeNullDefault Comments
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
PARTITION_NAMEvarchar(64)YesNULL
SUBPARTITION_NAMEvarchar(64)YesNULL
PARTITION_ORDINAL_POSITIONbigint(21)YesNULL
SUBPARTITION_ORDINAL_POSITIONbigint(21)YesNULL
PARTITION_METHODvarchar(18)YesNULL
SUBPARTITION_METHODvarchar(12)YesNULL
PARTITION_EXPRESSIONlongtextYesNULL
SUBPARTITION_EXPRESSIONlongtextYesNULL
PARTITION_DESCRIPTIONlongtextYesNULL
TABLE_ROWSbigint(21)No0
AVG_ROW_LENGTHbigint(21)No0
DATA_LENGTHbigint(21)No0
MAX_DATA_LENGTHbigint(21)YesNULL
INDEX_LENGTHbigint(21)No0
DATA_FREEbigint(21)No0
CREATE_TIMEdatetimeYesNULL
UPDATE_TIMEdatetimeYesNULL
CHECK_TIMEdatetimeYesNULL
CHECKSUMbigint(21)YesNULL
PARTITION_COMMENTvarchar(80)No
NODEGROUPvarchar(12)No
TABLESPACE_NAMEvarchar(64)YesNULL

PLUGINS

ColumnTypeNullDefault Comments
PLUGIN_NAMEvarchar(64)No
PLUGIN_VERSIONvarchar(20)No
PLUGIN_STATUSvarchar(10)No
PLUGIN_TYPEvarchar(80)No
PLUGIN_TYPE_VERSIONvarchar(20)No
PLUGIN_LIBRARYvarchar(64)YesNULL
PLUGIN_LIBRARY_VERSIONvarchar(20)YesNULL
PLUGIN_AUTHORvarchar(64)YesNULL
PLUGIN_DESCRIPTIONlongtextYesNULL
PLUGIN_LICENSEvarchar(80)YesNULL
LOAD_OPTIONvarchar(64)No

PROCESSLIST

ColumnTypeNullDefault Comments
IDbigint(21)No0
USERvarchar(32)No
HOSTvarchar(64)No
DBvarchar(64)YesNULL
COMMANDvarchar(16)No
TIMEint(7)No0
STATEvarchar(64)YesNULL
INFOlongtextYesNULL

PROFILING

ColumnTypeNullDefault Comments
QUERY_IDint(20)No0
SEQint(20)No0
STATEvarchar(30)No
DURATIONdecimal(9,6)No0.000000
CPU_USERdecimal(9,6)YesNULL
CPU_SYSTEMdecimal(9,6)YesNULL
CONTEXT_VOLUNTARYint(20)YesNULL
CONTEXT_INVOLUNTARYint(20)YesNULL
BLOCK_OPS_INint(20)YesNULL
BLOCK_OPS_OUTint(20)YesNULL
MESSAGES_SENTint(20)YesNULL
MESSAGES_RECEIVEDint(20)YesNULL
PAGE_FAULTS_MAJORint(20)YesNULL
PAGE_FAULTS_MINORint(20)YesNULL
SWAPSint(20)YesNULL
SOURCE_FUNCTIONvarchar(30)YesNULL
SOURCE_FILEvarchar(20)YesNULL
SOURCE_LINEint(20)YesNULL

REFERENTIAL_CONSTRAINTS

ColumnTypeNullDefault Comments
CONSTRAINT_CATALOGvarchar(512)No
CONSTRAINT_SCHEMAvarchar(64)No
CONSTRAINT_NAMEvarchar(64)No
UNIQUE_CONSTRAINT_CATALOGvarchar(512)No
UNIQUE_CONSTRAINT_SCHEMAvarchar(64)No
UNIQUE_CONSTRAINT_NAMEvarchar(64)YesNULL
MATCH_OPTIONvarchar(64)No
UPDATE_RULEvarchar(64)No
DELETE_RULEvarchar(64)No
TABLE_NAMEvarchar(64)No
REFERENCED_TABLE_NAMEvarchar(64)No

ROUTINES

ColumnTypeNullDefault Comments
SPECIFIC_NAMEvarchar(64)No
ROUTINE_CATALOGvarchar(512)No
ROUTINE_SCHEMAvarchar(64)No
ROUTINE_NAMEvarchar(64)No
ROUTINE_TYPEvarchar(9)No
DATA_TYPEvarchar(64)No
CHARACTER_MAXIMUM_LENGTHint(21)YesNULL
CHARACTER_OCTET_LENGTHint(21)YesNULL
NUMERIC_PRECISIONbigint(21)YesNULL
NUMERIC_SCALEint(21)YesNULL
DATETIME_PRECISIONbigint(21)YesNULL
CHARACTER_SET_NAMEvarchar(64)YesNULL
COLLATION_NAMEvarchar(64)YesNULL
DTD_IDENTIFIERlongtextYesNULL
ROUTINE_BODYvarchar(8)No
ROUTINE_DEFINITIONlongtextYesNULL
EXTERNAL_NAMEvarchar(64)YesNULL
EXTERNAL_LANGUAGEvarchar(64)YesNULL
PARAMETER_STYLEvarchar(8)No
IS_DETERMINISTICvarchar(3)No
SQL_DATA_ACCESSvarchar(64)No
SQL_PATHvarchar(64)YesNULL
SECURITY_TYPEvarchar(7)No
CREATEDdatetimeNo0000-00-00 00:00:00
LAST_ALTEREDdatetimeNo0000-00-00 00:00:00
SQL_MODEvarchar(8192)No
ROUTINE_COMMENTlongtextNo
DEFINERvarchar(93)No
CHARACTER_SET_CLIENTvarchar(32)No
COLLATION_CONNECTIONvarchar(32)No
DATABASE_COLLATIONvarchar(32)No

SCHEMATA

ColumnTypeNullDefault Comments
CATALOG_NAMEvarchar(512)No
SCHEMA_NAMEvarchar(64)No
DEFAULT_CHARACTER_SET_NAMEvarchar(32)No
DEFAULT_COLLATION_NAMEvarchar(32)No
SQL_PATHvarchar(512)YesNULL

SCHEMA_PRIVILEGES

ColumnTypeNullDefault Comments
GRANTEEvarchar(81)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

SESSION_STATUS

ColumnTypeNullDefault Comments
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(1024)YesNULL

SESSION_VARIABLES

ColumnTypeNullDefault Comments
VARIABLE_NAMEvarchar(64)No
VARIABLE_VALUEvarchar(1024)YesNULL

STATISTICS

ColumnTypeNullDefault Comments
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
NON_UNIQUEbigint(1)No0
INDEX_SCHEMAvarchar(64)No
INDEX_NAMEvarchar(64)No
SEQ_IN_INDEXbigint(2)No0
COLUMN_NAMEvarchar(64)No
COLLATIONvarchar(1)YesNULL
CARDINALITYbigint(21)YesNULL
SUB_PARTbigint(3)YesNULL
PACKEDvarchar(10)YesNULL
NULLABLEvarchar(3)No
INDEX_TYPEvarchar(16)No
COMMENTvarchar(16)YesNULL
INDEX_COMMENTvarchar(1024)No

TABLES

ColumnTypeNullDefault Comments
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
TABLE_TYPEvarchar(64)No
ENGINEvarchar(64)YesNULL
VERSIONbigint(21)YesNULL
ROW_FORMATvarchar(10)YesNULL
TABLE_ROWSbigint(21)YesNULL
AVG_ROW_LENGTHbigint(21)YesNULL
DATA_LENGTHbigint(21)YesNULL
MAX_DATA_LENGTHbigint(21)YesNULL
INDEX_LENGTHbigint(21)YesNULL
DATA_FREEbigint(21)YesNULL
AUTO_INCREMENTbigint(21)YesNULL
CREATE_TIMEdatetimeYesNULL
UPDATE_TIMEdatetimeYesNULL
CHECK_TIMEdatetimeYesNULL
TABLE_COLLATIONvarchar(32)YesNULL
CHECKSUMbigint(21)YesNULL
CREATE_OPTIONSvarchar(255)YesNULL
TABLE_COMMENTvarchar(2048)No

TABLESPACES

ColumnTypeNullDefault Comments
TABLESPACE_NAMEvarchar(64)No
ENGINEvarchar(64)No
TABLESPACE_TYPEvarchar(64)YesNULL
LOGFILE_GROUP_NAMEvarchar(64)YesNULL
EXTENT_SIZEbigint(21)YesNULL
AUTOEXTEND_SIZEbigint(21)YesNULL
MAXIMUM_SIZEbigint(21)YesNULL
NODEGROUP_IDbigint(21)YesNULL
TABLESPACE_COMMENTvarchar(2048)YesNULL

TABLE_CONSTRAINTS

ColumnTypeNullDefault Comments
CONSTRAINT_CATALOGvarchar(512)No
CONSTRAINT_SCHEMAvarchar(64)No
CONSTRAINT_NAMEvarchar(64)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
CONSTRAINT_TYPEvarchar(64)No

TABLE_PRIVILEGES

ColumnTypeNullDefault Comments
GRANTEEvarchar(81)No
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

TRIGGERS

ColumnTypeNullDefault Comments
TRIGGER_CATALOGvarchar(512)No
TRIGGER_SCHEMAvarchar(64)No
TRIGGER_NAMEvarchar(64)No
EVENT_MANIPULATIONvarchar(6)No
EVENT_OBJECT_CATALOGvarchar(512)No
EVENT_OBJECT_SCHEMAvarchar(64)No
EVENT_OBJECT_TABLEvarchar(64)No
ACTION_ORDERbigint(4)No0
ACTION_CONDITIONlongtextYesNULL
ACTION_STATEMENTlongtextNo
ACTION_ORIENTATIONvarchar(9)No
ACTION_TIMINGvarchar(6)No
ACTION_REFERENCE_OLD_TABLEvarchar(64)YesNULL
ACTION_REFERENCE_NEW_TABLEvarchar(64)YesNULL
ACTION_REFERENCE_OLD_ROWvarchar(3)No
ACTION_REFERENCE_NEW_ROWvarchar(3)No
CREATEDdatetime(2)YesNULL
SQL_MODEvarchar(8192)No
DEFINERvarchar(93)No
CHARACTER_SET_CLIENTvarchar(32)No
COLLATION_CONNECTIONvarchar(32)No
DATABASE_COLLATIONvarchar(32)No

USER_PRIVILEGES

ColumnTypeNullDefault Comments
GRANTEEvarchar(81)No
TABLE_CATALOGvarchar(512)No
PRIVILEGE_TYPEvarchar(64)No
IS_GRANTABLEvarchar(3)No

VIEWS

ColumnTypeNullDefault Comments
TABLE_CATALOGvarchar(512)No
TABLE_SCHEMAvarchar(64)No
TABLE_NAMEvarchar(64)No
VIEW_DEFINITIONlongtextNo
CHECK_OPTIONvarchar(8)No
IS_UPDATABLEvarchar(3)No
DEFINERvarchar(93)No
SECURITY_TYPEvarchar(7)No
CHARACTER_SET_CLIENTvarchar(32)No
COLLATION_CONNECTIONvarchar(32)No
XML 地图 | Sitemap 地图