資料庫表結構導出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;
查詢完成後，粘貼指定的列即可