# `VERSION::8.5.0` Identify Global Index

```
tidb> SHOW CREATE TABLE t1\G
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `col1` int NOT NULL,
  `col2` date NOT NULL,
  `col3` int NOT NULL,
  `col4` int NOT NULL,
  UNIQUE KEY `uidx12` (`col1`,`col2`) ~!@/*T![global_index] GLOBAL */@!~,
  UNIQUE KEY `uidx3` (`col3`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
PARTITION BY HASH (`col3`) PARTITIONS 4
1 row in set (0.01 sec)
```

```
tidb> SELECT * FROM INFORMATION_SCHEMA.TIDB_INDEXES WHERE table_name='t1';
+--------------+------------+------------+----------+--------------+ ... +-----------+
| TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | KEY_NAME | SEQ_IN_INDEX | ... |~!@ IS_GLOBAL @!~|
+--------------+------------+------------+----------+--------------+ ... +-----------+
| test         | t1         |          0 | uidx12   |            1 | ... |        ~!@ 1 @!~|
| test         | t1         |          0 | uidx12   |            2 | ... |        ~!@ 1 @!~|
| test         | t1         |          0 | uidx3    |            1 | ... |         0 |
+--------------+------------+------------+----------+--------------+ ... +-----------+
3 rows in set (0.01 sec)
```

------------------------------------------------------------------------------
You can identify global index by using `SHOW CREATE TABLe <TABLE_NAME>` or query the INFORMATION_SCHEMA table.