# Identify objects in tablespace

**URL:** <https://forums.percona.com/t/identify-objects-in-tablespace/25687>\
**Category:** Percona Server for MySQL\
**Created:** [October 5, 2023, 1:17pm UTC](https://forums.percona.com/t/identify-objects-in-tablespace/25687 "2023-10-05T13:17:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Percona\_new](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/percona_new/32/9299_2.png) [@Percona\_new](https://forums.percona.com/u/Percona_new)\
**Post date:** [October 5, 2023, 1:17pm UTC](https://forums.percona.com/t/identify-objects-in-tablespace/25687/1 "2023-10-05T13:17:50Z")

</div>

Hello team, I’ve come to ask for your help because I’ve had difficulty finding a query that allows us to retrieve the objects (tables/indexes) that are hosted in a particular tablespace.  
Version: 8.0.27-18 Percona Server.  
I appreciate any assistance in advance!

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [October 5, 2023, 3:03pm UTC](https://forums.percona.com/t/identify-objects-in-tablespace/25687/2 "2023-10-05T15:03:08Z")

</div>

Hello @Percona_new,  
Check out `information_schema.tables` and `information_schema.constraints`

---

<div class="post-metadata">

**Author:** ![Percona\_new](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/percona_new/32/9299_2.png) [@Percona\_new](https://forums.percona.com/u/Percona_new)\
**Post date:** [October 5, 2023, 3:25pm UTC](https://forums.percona.com/t/identify-objects-in-tablespace/25687/3 "2023-10-05T15:25:14Z")

</div>

Thank you Matthew! The version we are running does not have information\_schema.constraints and in information\_schema.tables I cannot find the relation with the tablespace where the table is located.

Can you clarify please?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [October 5, 2023, 3:51pm UTC](https://forums.percona.com/t/identify-objects-in-tablespace/25687/4 "2023-10-05T15:51:31Z")

</div>

Look at `INNODB_TABLESPACES`. There are many tables inside `information_schema` that have information on tables, tablespaces, indexes, etc.

> The version we are running does not have information\_schema.constraints

I’m using Percona Server 8.0.34 which is the current GA release. If you have an earlier version, you’ll have to just take time and look through all the `INNODB_*` tables inside the information\_schema and you will find the info that you need.