Unanswered: Any ways to export table structure quickly?
We have more than 100 tables and need to generate creation scripts of them.
I found ddlgen (for table) and defncopy ( for index,trigger,sp) to implement this. Besides this, is there any other utility or tool to use? For example, in oracle, I can use pl/sql developer or exp utility. It is quite simple.
Please advise. Thanks.
There is a tool called SQLDBX. Here you can run a select statment on the required table. When the results appear in the result window, you can right-click on the first row and generate a create statment for that table. Hope this helps.