On an ER diagram I have several tables that all need to have a group of 6 columns that need to be included in each table. I created the 6 columns in the first table but can’t seem to find a way to copy them and then paste them in to another entity/table. The only way I have been able to do it is to duplicate the columns which adds a “2” to the end of each column name and then drag the copies to the target table and edit them to remove the “2”.
There must be a better way to do this. What am I missing?
TIA