By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE STUDENT(
ROLL_NO INT NOT NULL,
STU_NAME VARCHAR (35) NOT NULL UNIQUE,
STU_AGE INT NOT NULL,
STU_ADDRESS VARCHAR (35) UNIQUE,
CONSTRAINT PK_Student PRIMARY KEY (ROLL_NO)
);
SHOW CREATE TABLE STUDENT;
| Table | Create Table |
|---|---|
| STUDENT | CREATE TABLE `STUDENT` ( `ROLL_NO` int NOT NULL, `STU_NAME` varchar(35) NOT NULL, `STU_AGE` int NOT NULL, `STU_ADDRESS` varchar(35) DEFAULT NULL, PRIMARY KEY (`ROLL_NO`), UNIQUE KEY `STU_NAME` (`STU_NAME`), UNIQUE KEY `STU_ADDRESS` (`STU_ADDRESS`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
SHOW INDEX FROM STUDENT;
SHOW EXTENDED INDEX FROM STUDENT;
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STUDENT | 0 | PRIMARY | 1 | ROLL_NO | A | 0 | null | null | BTREE | YES | null | |||
| STUDENT | 0 | STU_NAME | 1 | STU_NAME | A | 0 | null | null | BTREE | YES | null | |||
| STUDENT | 0 | STU_ADDRESS | 1 | STU_ADDRESS | A | 0 | null | null | YES | BTREE | YES | null |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STUDENT | 0 | PRIMARY | 1 | ROLL_NO | A | 0 | null | null | BTREE | YES | null | |||
| STUDENT | 0 | PRIMARY | 2 | DB_TRX_ID | A | null | null | null | BTREE | YES | null | |||
| STUDENT | 0 | PRIMARY | 3 | DB_ROLL_PTR | A | null | null | null | BTREE | YES | null | |||
| STUDENT | 0 | PRIMARY | 4 | STU_NAME | A | null | null | null | BTREE | YES | null | |||
| STUDENT | 0 | PRIMARY | 5 | STU_AGE | A | null | null | null | BTREE | YES | null | |||
| STUDENT | 0 | PRIMARY | 6 | STU_ADDRESS | A | null | null | null | YES | BTREE | YES | null | ||
| STUDENT | 0 | STU_NAME | 1 | STU_NAME | A | 0 | null | null | BTREE | YES | null | |||
| STUDENT | 0 | STU_NAME | 2 | ROLL_NO | A | null | null | null | BTREE | YES | null | |||
| STUDENT | 0 | STU_ADDRESS | 1 | STU_ADDRESS | A | 0 | null | null | YES | BTREE | YES | null | ||
| STUDENT | 0 | STU_ADDRESS | 2 | ROLL_NO | A | null | null | null | BTREE | YES | null |