snippetsqlMinor
How to display database structure in phpMyAdmin?
Viewed 0 times
databasephpmyadminstructurehowdisplay
Problem
Is there any way to generate a report of my database structure using phpMyAdmin? What I would like is a table format like the following, and an Entity Relationship table.
Table name: List
Description: Subscriber list information
Field Type Null Description
ListID Int N
ListName Varchar N
ListFromName Varchar N Default person represent for the mail
ListReplyTo Varchar N Default return address
ListSubject Varchar N Default subject title of mail
ListRemindSub Int N Whether notify when people subscribe
ListRemindUnSub Int N Whether notify when people unsubscribe
ListCreateDate Date N
Table name: Campaign
Description: Mail campaign information
Field Type Null Description
CampID Int N
CampReplyTo Varchar N Specific return mail
CampFromName Varchar N The person represent for the mail
CampSubject Varchar N Subject title of mail
CampFb Int N Whether include Facebook reminder
CampGA Int N Whether include Google AnalyticSolution
select DB, go to export, select tables that you want the structure (top left),deselect "DATA"(middle-center) and select a name and you will be able to export only the structure.
or go to your "database" then "check all" (just below the tables) and change the option from "With Selected:" to "print view". it will show the relations too, and it will looks like this:
or go to your "database" then "check all" (just below the tables) and change the option from "With Selected:" to "print view". it will show the relations too, and it will looks like this:
Context
StackExchange Database Administrators Q#15537, answer score: 5
Revisions (0)
No revisions yet.