> 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_virtual-table.md).

# Information Schema INNODB\_SYS\_VIRTUAL Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `INNODB_SYS_VIRTUAL` table contains information about base columns of [virtual columns](/docs/server/reference/sql-statements/data-definition/create/generated-columns.md). The `PROCESS` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md) is required to view the table.

It contains the following columns:

| Field     | Type                | Null | Default |
| --------- | ------------------- | ---- | ------- |
| TABLE\_ID | bigint(21) unsigned | NO   | 0       |
| POS       | int(11) unsigned    | NO   | 0       |
| BASE\_POS | int(11) unsigned    | NO   | 0       |

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

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