数据库表结构导出word

Ⅰ 怎么把SQL数据库表的结构导出到word

导出表结构，进入命令行：
mysql
>
mysqlmp
--opt
--default-character-set=gbk
db_test
-d
>
db_test_d.sql
导出表数据：
mysql
>
mysqlmp
--opt
--default-character-set=gbk
db_test
-t
>
db_test_t.sql
解释说明：mysqlmp
导出命令
-d
表结构
-t表数据
不加内就是结构加容数据

Ⅱ 怎么把plsql表结构导出显示在word文档里

不支持直接导出WORD，运行查询，得到结果后，复到制WORD表里即可
SELECT t1.Table_Name AS "表名称",
t3.comments AS "表说明",
t1.Column_Name AS "字段名称",
t1.Data_Type AS "数据类型",
t1.Data_Length AS "长度",
t1.NullAble AS "是否为空",
t2.Comments AS "字段说明",
t1.Data_Default "默认值"
FROM cols t1 left join user_col_comments t2
on t1.Table_name=t2.Table_name and t1.Column_Name=t2.Column_Name
left join user_tab_comments t3
on t1.Table_name=t3.Table_name
WHERE NOT EXISTS ( SELECT t4.Object_Name FROM User_objects t4
WHERE t4.Object_Type='TABLE'
AND t4.Temporary='Y'
AND t4.Object_Name=t1.Table_Name )
ORDER BY t1.Table_Name, t1.Column_ID;
查询完成后，粘贴指定的列即可