MySql獲取表結(jié)構(gòu)信息

SELECTTABLE_NAME,TABLE_COMMENT FROMinformation_schema.`TABLES` WHERETABLE_SCHEMA = 'dm' -- dm 是數(shù)據(jù)庫名稱，需替換 ORDER BYTABLE_NAME;

MySql獲取字段信息

SELECTTABLE_NAME AS 'tableName',COLUMN_NAME AS 'columnName',COLUMN_COMMENT AS 'columnComment',IS_NULLABLE AS 'nullable',DATA_TYPE AS 'dataType',CHARACTER_MAXIMUM_LENGTH AS 'strLength',NUMERIC_PRECISION AS 'numLength',NUMERIC_SCALE AS 'numBit' FROMinformation_schema.`COLUMNS` WHERETABLE_SCHEMA = 'dm' -- dm 是數(shù)據(jù)庫名稱，需替換 AND TABLE_NAME = 'base_auth_resource' -- base_auth_resource 是表名，需替換 ORDER BYTABLE_NAME,ORDINAL_POSITION;

Oracle獲取表結(jié)構(gòu)信息

select t.table_name, c.COMMENTSfrom user_tables t, user_tab_comments cwhere t.TABLE_NAME = c.TABLE_NAMEorder by t.table_name

Oracle獲取字段信息

select t.TABLE_NAME AS tableName,t.COLUMN_NAME AS columnName,c.COMMENTS AS columnComment,t.NULLABLE AS nullable,t.DATA_TYPE AS dataType,t.CHAR_LENGTH AS strLength,t.data_length as dataLength,t.DATA_PRECISION AS numLength,t.DATA_SCALE AS numBitfrom user_tab_columns t, user_col_comments cwhere t.TABLE_NAME = c.TABLE_NAMEand t.COLUMN_NAME = c.COLUMN_NAMEand t.TABLE_NAME = 'EMP' -- EMP 是表名，需替換order by t.TABLE_NAME, t.COLUMN_ID

總結(jié)

以上是生活随笔為你收集整理的MySql 、Oracle 获取表结构和字段信息的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。