Toad World® Forums

Copy Column


#1

Hello TDM community,

is there any way to copy a column from table A to table B, specially when the column has a Domain ? background, I added a new column to table A and wouldlike to have the same column in 10 other tables.

Ilja


#2

Hi Ilja,

Yes, you can copy columns. There are several ways how to do it.
Please watch:
http://modeling.inside.quest.com/entry.jspa?externalID=1675&categoryID=158
http://modeling.inside.quest.com/entry.jspa?externalID=1676&categoryID=158

Or see the Help file, Index tab, type “attribute”, select “copy”.

The attribute should be copied with the domain.

Regards,

Vladka


#3

Hi Ilja,

sure this is available. Please see the following video:
http://modeling.inside.quest.com/entry.jspa?externalID=1675&categoryID=158

or see help file section Model | Entity Relationship Diagram | Attributes | Copy attributes (or click the Index tab in help file and type “copy”).

Regards,

Vaclav


#4

thanks you two for the link,helpsme a lot.

Ilja