Take the 2-minute tour ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.

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

3 Answers 3

up vote 2 down vote accepted

For databases that implement information schema, use:

SELECT table_name, table_comment 
FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema='my_cdrupal_database' 
share|improve this answer

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

SHOW TABLE STATUS

See Screenshot below for example.

enter image description here

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
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 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 at 4:50
    
Did you read the description in the answer? That's exactly what it does –  Clive Feb 26 at 7:52

Your Answer

 
discard

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.