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.

3 Answers 3


For databases that implement information schema, use:

SELECT table_name, table_comment 
WHERE table_schema='my_cdrupal_database' 

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.

  • 1
    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, 2014 at 13:49
  • i don't want schema.I want each table description and looks like schema module doesn't provide me with that. Feb 26, 2014 at 4:50
  • Did you read the description in the answer? That's exactly what it does
    – Clive
    Feb 26, 2014 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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