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.


For databases that implement information schema, use:

SELECT table_name, table_comment 
WHERE table_schema='my_cdrupal_database' 
| 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.

| improve this answer | |
  • 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 '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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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