frosty1
asked on
How to copy 2 foreign key tables in mssql 2008
I have 2 tables:
- Orders
- OrderItems ( PK on orderId )
How can i copy the both these tables to the follow names and key the PK relationship
- CampaignOrder
- CampaignOrderItems
ie so that i have 4 tables
- Orders
- OrderItems ( PK on orderId )
How can i copy the both these tables to the follow names and key the PK relationship
- CampaignOrder
- CampaignOrderItems
ie so that i have 4 tables
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.