What are the challenges you face when working across database platforms? Take the survey
Options

Hardcode the Foreign Key value

hashcoderzhashcoderz Posts: 2
Hi

I have a User table with UserStatusId as foreign key, where UserStatus table have two rows

UserStatusId Name
1 Active
2 Deleted

I am going to populate the User table, but i need to populate only Active users, that means UserStatusId is 1.

How should i do it in SQL Data Generator 1? Any suggestions?

Comments

Sign In or Register to comment.