Can i view tables which are under Partition in my sql

Question

Can i view tables which are under Partition in my sql??? How to view such tables???

Answer 1

Your question is a bit unclear, but if you mean "How do I see which tables are using partinioning in MySQL" and you are using at least MySQL 5.1.6. then you can use the INFORMATION_SCHEMA.PARTITION table:

SELECT TABLE_NAME, PARTITION_NAME FROM INFORMATION_SCHEMA.PARTITIONS;