TIDB: 元数据查询指令

阅读量：

一、获取表描述

复制代码

    select table_name,table_comment from information_schema.TABLES where table_schema = '%s' and table_name in (%s)

复制代码

    SELECT * FROM information_schema.views WHERE TABLE_NAME = '%s' and TABLE_SCHEMA = '%s'

复制代码

    select table_name from information_schema.TABLES where table_name = '%s' and table_schema = '%s'

复制代码

    select table_name,column_name,ordinal_position,column_default,EXTRA,is_nullable,data_type,column_comment,column_key,numeric_p

还没有任何评论哟~