I am using the following bit of SQL to get a list of the primary keys in my DB , named 'RMCMS':

Code:
SELECT `COLUMN_NAME` , `TABLE_NAME`
FROM `statistics`
WHERE `INDEX_SCHEMA` = 'RMCMS'
AND `INDEX_NAME` = 'PRIMARY'
LIMIT 0 , 30
I was wondering if there was a more efficient way to do do this. I also have heard that `information_schema` is not always accessible (for example in a shared host) is this true?

Thanks in advance