How do I copy 5 columns from one table to another?

[ooboywonder]

Anyone know how I can easily copy 5 columns from one table to another? I have many tables that all share the same 5 security related columns.

-or-

Is there a way I create a table super class that I can inherit these 5 columns from? Parden if I use wrong terminology...

[thomaskilian]

The only solution seem to be: export via XML, use your favourite editor and re-import. You can also use the generalization, but the inherited colums do not get generated when you use Generate DDL  :-/

[Amancay]

Hi!

Have you tried to expand the souce table in the project view while a diagram with the target table is shown and then click and drag the columns (one at a time)?

A

[ooboywonder]

Sweeeeeeet!