Question

toad如何导出数据库内所有表的脚本

Answer 1

最关键是要能导出表中的数据类似：

INSERT INTO [authors]
([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract])
VALUES
( '172-32-1176 ', 'White ', 'Johnson ', '408 496-7223 ', '10932 Bigge Rd. ', 'Menlo Park ', 'CA ', '94025 ', 1);

INSERT INTO [authors]
([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract])
VALUES
( '213-46-8915 ', 'Green ', 'Marjorie ', '415 986-7020 ', '309 63rd St. #411 ', 'Oakland ', 'CA ', '94618 ', 1);