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

SHOW CREATE TABLE mytable;

thanks a lot!!

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.