How do display the structure of mysql database

Because tables doesn't contain any info on which types are the the table columns — Dimitry K. That works a treat! C is a language, a function in a C program is a construct within that language. Yes, definitely a reason to vote down Gimno 6, 3 3 gold badges 36 36 silver badges 38 38 bronze badges. Emil H I like this, it gives the create statements. Shudipta Sharma Shudipta Sharma 3, 2 2 gold badges 14 14 silver badges 27 27 bronze badges. You can pick any one of the command below.

Vasanth Saminathan Vasanth Saminathan 4 4 bronze badges. Sh4dy Sh4dy 65 9 9 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

Field indicates the column name, Type is the data type for the column, NULL indicates whether the column can contain NULL values, Key indicates whether the column is indexed, and Default specifies the column's default value. Connecting to and Disconnecting from the Server.

Creating and Selecting a Database. Retrieving Information from a Table. Selecting Particular Columns. Getting Information About Databases and Tables. Angular 7. Machine Learning. Data Structures.

Operating System. Computer Network. Compiler Design. Computer Organization. Discrete Mathematics. Ethical Hacking. Computer Graphics. Software Engineering. Web Technology. Cyber Security. C Programming. Control System. Data Mining. Data Warehouse. Javatpoint Services JavaTpoint offers too many high quality services. Step 2: Switch to a specific database. We will get the following screen: Now do the following steps to show the table information: 1.

See the below image: Now, click the icon i shown in the red rectangular box. It will display the following image: Finally, click on the " Columns " menu to display the table structure.