Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011

    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.

  2. #2
    Join Date
    Feb 2012

    Using SQLDBX


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts