Finding out if a table is partitioned in mysql

Googling about it and searching EE didn't give me immediate answers, so I post the question - how do you know from within mysql prompt only if a MySQL table uses partitioning?  "desc table_name" doesn't give any more than the basic info.  Thanks.  The reason why via mysql prompt only is the database is on Amazon RDS so I don't have access to the filesystem and I don't want to have to install tools such as phpmyadmin on my ec2 instance just to that.  Thanks.
LVL 24
johanntagleAsked:
Who is Participating?
 
mrjoltcolaConnect With a Mentor Commented:
EXPLAIN PARTITIONS SELECT * FROM tbl


Also use the data dictionary for details on the partition

http://dev.mysql.com/doc/refman/5.1/en/partitioning-info.html
0
 
johanntagleAuthor Commented:
Thanks again mrjoltcola!

Funny how i missed that part of the documentation. I guess coffee is failing me - maybe I need.... Jolt Cola... LOL
0
 
mrjoltcolaCommented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.