INFORMATION_SCHEMA > COLUMNS shows outdated information

Here my MariaDB version:

# mariadb --version
mariadb  Ver 15.1 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper

running under Ubuntu 20.04.
I created a table:

CREATE TABLE `anagrafica_famiglie` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `famiglia` varchar(255) NOT NULL,
 `pagamento` tinyint(1) DEFAULT 0,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

after some time, from PhpMyAdmin I changed the name of the column pagamento to pagamento_nuovo. Now I see the new name everywhere in the database, I can make SQL queries with this name, etc…

But the INFORMATION_SCHEMA still shows the old name:

SELECT DATA_TYPE, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name="anagrafica_famiglie"

DATA_TYPE COLUMN_NAME
int       id
varchar   famiglia
tinyint   pagamento

Is there anything I have to do in order to update the INFORMATION_SCHEMA table?

You need to sign in to view this answers