stablish relation

Yes you can if there is correct relation between data means if child table have some data and parent table has no data then there is violation of foreign key.

 

Best part is to create new tables, define their relationship and import data from old table to new table.

 

Thanks,

Manish 

FYI 

Generally we have 3 types of DB designs

 

1- Transactional DBs

2- BI DB,s

3- Combination (thats the the 2 above)

 

 

hi,

 

you can try below link

 

https://stackoverflow.com/questions/42577979/how-to-add-a-primary-key-and-foreign-key-to-an-existing-table-in-microsoft-sql-s

 

or try this

note that before adding foreign key that key should exist in the primary table primary key