how can we check whether the primary and foreign key are working in the database in mysql
srpa01red
0
Newbie Poster
Recommended Answers
Jump to PostI think you need not to check if you have created constraints properly.
But still if you want to check, then to chekc PK try to insert record with existing PK value, and to check FK try to insert record with FK value that does not exist in master table …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.