You can get any table's details from the following query:
SHOW TABLE STATUS FROM 'your DB name' LIKE '%your table name%' ;
For getting the auto increment value on a table you can use the following query:
SELECT AUTO_INCREMENT
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your db name'
AND TABLE_NAME = 'your table name';
Good luck,
OI