mysql数据库导出数据字典
USE information_schema;SELECTT.TABLE_COMMENT AS ‘表名称’,C.TABLE_NAME AS ‘表名’,C.COLUMN_NAME AS ‘字段名’,C.COLUMN_TYPE AS ‘数据类型’,C.IS_NULLABLE AS ‘允许为空’,C.EXTRA AS ‘PK’,C.COLUMN_COMMENT AS ‘字段说明’FROMCOLUMNS CINNER JOIN TABLES T ON C.TABLE_SCHEMA = T.TABLE_SCHEMAAND C.TABLE_NAME = T.TABLE_NAMET.TABLE_SCHEMA = ‘数据库名称’
Oracle数据库导出数据字典
SELECT
C.COMMENTS AS “表名称”,
A.TABLE_NAME AS “表名”,
A.COLUMN_NAME AS “字段名”,
DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'(‘||A.DATA_PRECISION||’,’||A.DATA_SCALE||’)’),
A.DATA_TYPE||'(‘||A.CHAR_LENGTH||’)’) as “数据类型”,
A.NULLABLE AS “允许为空”,
B.comments AS “字段说明”
FROM sys.user_tab_columns A,sys.user_tab_comments C,sys.user_col_comments B
WHERE A.table_name=B.table_name AND A.table_name=C.table_name AND A.COLUMN_NAME=B.COLUMN_NAME
ORDER BY A.TABLE_NAME
oracle导出数据字典需要登录到普通用户的当前数据表中。
转载请注明:夜阑小雨 » mysql数据库导出数据字典-Oracle数据库导出数据字典