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

Re: foreign key constraint 80 80

SHOW CREATE TABLE mytable;

Re: foreign key constraint 80 80

thanks a lot!!

Be a part of the DaniWeb community

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