Database Each table Usage

Question

Where can I see the each table usage, which is getting created in default installation of a Drupal site.

Likes node table - used to store all nodes in them. For other tables where i can get the information. Any documentation for each table usage in database??

Thanks in advance.

Answer 1

For databases that implement information schema, use:

SELECT table_name, table_comment 
FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema='my_cdrupal_database' 

Answer 2

Just to add the Drupal-y answer...

You can install the Schema module for that, amongst its features is:

Schema documentation: hyperlinked display of the schema's embedded documentation explaining what each table and field is for.

Answer 3

Run below query on your database and see last column in the result table.

SHOW TABLE STATUS

See Screenshot below for example.