Simple statement to show all primary keys from all MySQL tables?

[Joseph_Sliker]

Hi;

With MySQL I understand how to use SHOW TABLES, and DESCRIBE and such, I also understand that I can do things like "SHOW KEYS FROM MyTable WHERE Key_name='PRIMARY'" to just get the primary key.

But is there a simple MySQL statement that will show me ALL the primary keys for all of my tables in one fell swoop? I don't seem to be able to use the % wildcard in a statement like "SHOW KEYS FROM MyDB.% WHERE Key_name='PRIMARY'".

I've been looking at the MySQL documentation but am not clear if what I'm asking is possible.

Thanks.

[djjjozsi]

i know its not the easiest way, but a batch method to get a list of primary keys in your databases.

SELECT T.TABLE_SCHEMA AS dbname , T.TABLE_NAME AS table_name, T.CONSTRAINT_NAME, C.COLUMN_NAME AS column_name, C.ORDINAL_POSITION
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS T
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE C ON T.CONSTRAINT_NAME = C.CONSTRAINT_NAME
WHERE T.CONSTRAINT_TYPE = 'PRIMARY KEY'