Drupal Answers is a question and answer site for Drupal developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 2 down vote accepted

For databases that implement information schema, use:

SELECT table_name, table_comment 
WHERE table_schema='my_cdrupal_database' 
share|improve this answer

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.

share|improve this answer
Totally forgot about that. I guess because it was always faster for me to just look at schema in db client. – Mołot Feb 25 '14 at 13:49
i don't want schema.I want each table description and looks like schema module doesn't provide me with that. – NewToDrupal Feb 26 '14 at 4:50
Did you read the description in the answer? That's exactly what it does – Clive Feb 26 '14 at 7:52

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


See Screenshot below for example.

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.