What is the information_schema database?

In MySQL version 5.02 and above there is an additional database called information_schema. This database provides access to the database metadata. This includes the name of a database or a table, the data type of a column, access privileges, etc.


information_schema is the information database where the information about all the other databases is kept. It is a built-in virtual database with the sole purpose of providing information about the database system itself. The MySQL server automatically populates the tables in the information_schema. 

 

The important thing to remember about the information_schema database is that you can query it, but you cannot change its structure or modify its data.

  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

Can I change the name of a MySQL database?

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...

How can I empty a MySQL database?

The easiest way to empty a MySQL database is through phpMyAdmin.  Once in phpMyAdmin, select the...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...