What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata.

 

Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.

 INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.

 

Therefore, you can safely ignore these tables. They are read-only so they can't be edited or removed.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...

How do I check the size of my database?

Using the below mentioned steps, we will show you how to check the size of your database so you...

I need a different version of PHP/MySQL

If for some reason you cannot install programs on your server like Joomla, Drupal, WordPress,...

How do I optimze mysql in Cpanel?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How do I optimze mysql in plesk ?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...