> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_datafiles-table.md).

# Information Schema INNODB\_SYS\_DATAFILES Table

{% hint style="info" %}
This table is deprecated and was removed in MariaDB 10.6.0.
{% endhint %}

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `INNODB_SYS_DATAFILES` table contains information about InnoDB datafile paths. It was intended to provide metadata for tablespaces inside InnoDB tables, which was never implemented in MariaDB and was removed in [MariaDB 10.6](/docs/release-notes/community-server/10.6/what-is-mariadb-106.md). The `PROCESS` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md) was required to view the table.

It contains the following columns:

| Column | Description                                                                                                                                                                                                                          |
| ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| SPACE  | Numeric tablespace. Matches the [INNODB\_SYS\_TABLES.SPACE](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_tables-table.md) value. |
| PATH   | Tablespace datafile path.                                                                                                                                                                                                            |

## Example

```sql
SELECT * FROM INNODB_SYS_DATAFILES;
+-------+--------------------------------+
| SPACE | PATH                           |
+-------+--------------------------------+
|    19 | ./test/t2.ibd                  |
|    20 | ./test/t3.ibd                  |
...
|    68 | ./test/animals.ibd             |
|    69 | ./test/animal_count.ibd        |
|    70 | ./test/t.ibd                   |
+-------+--------------------------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}