I have two tables:
index, int, primary key, is identity
index, bigint, primary key, is identity
I want to add foreign key and connect these two tables via index field.
The problem is: these two fields are of different type.
1. Looks like I cannot change the type of the index field.
2. Looks like I can delete index field and the add another index field, problem is: I cannot make this field "is identity".
Is there any way I can solve my problem?
Is there any editor to open "StarterSite.sdf" and make some more advanced changes there?