You can use queries to copy the column's data from the original column to the new column. Use the Query Designer to run an update query to add the data to the table to which you copied the columns.
- In the Database window, click Database Diagrams
under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar. - In your database diagram, select the columns that you want to copy.
- Click the Copy button on the toolbar. This action copies the selection from the table and places the column and its current set of properties on the Clipboard.
- Position the cursor in the table at the location where you want to insert the columns.
- Click the Paste button on the toolbar. The column and its properties are inserted at the new location.
When you copy a database column that has a user-defined data type from one database to another, the user-defined data type may not be available in the destination database. In such a case, the column will be assigned the nearest matching base data type available in that database.