I agree to Idea Rename table
Voting Disabled

4 votes

I disagree to Idea Rename table

Rank5

Idea#8

This idea is active.
Modeling »

Rename table

I want to rename a table and add a few columns. How can I put this into Toad Data Modeler and create the correct alter script?

Submitted by 2 years ago

Comments (2)

  1. You can change table name, add columns, then put RENAME TABLE statement as 'before script'.

    There is no best way to automate this part. Of course TDM may track name changes. but often it will generate unneeded changes - especially at beginning of development, while names are changing often

    2 years ago
    0 Agreed
    0 Disagreed
  2. Moderator

    Hi, we know this area deserves to be improved. As a workaround you might find useful the following approach: http://blogs.inside.quest.com/modeling/2011/03/02/did-you-rename-a-column/

    It requires some scripting, but you might save some time.

    2 years ago
    1 Agreed
    0 Disagreed

Vote Activity Show

Events

  1. The idea was posted
    2 years ago