stablish relation

Question

i have created some table with diffrent num or column but i forget to set Foreign Key is there any way to create it now

Manish Kumar · Answer

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

Shahriar Nikkhah · Answer

FYI Generally we have 3 types of DB designs 1- Transactional DBs 2- BI DB,s 3- Combination (thats the the 2 above) In Transactional DBs (old School approch) you set the FK they way everyone does In Transactional DBs (Large amount of data) you set the FK they way everyone does BUT it must be disabled Good luck

Rafnas T P · Answer

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 ALTER TABLE foreinkeytablename ADD FOREIGN KEY (foreinkeytablenameID) REFERENCES primarykeytablename(primarykeytablenameid) note that before adding foreign key that key should exist in the primary table primary key

stablish relation

Answers (3)