how do i find the foreign key and primary key constraints of a particular table through a sql query?

Recommended Answers

SHOW CREATE TABLE mytable;

Jump to Post

All 2 Replies

SHOW CREATE TABLE mytable;

thanks a lot!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.