Which command is used to see the structure of the table in MySQL?

Question

To show the schema, we can use the DESC command. This gives the description about the table structure. 29 нояб. 2018 г.

Which command is used to see the structure of a table?

Since in database we have tables, that's why we use DESCRIBE or DESC(both are same) command to describe the structure of a table. Syntax: DESCRIBE one; OR DESC one; Note : We can use either DESCRIBE or DESC(both are Case Insensitive).

What is the command to see the structure of table in SQL?

If we want to show the structure of a database table or tables in the server then, we will use the SQL command DESCRIBE or other keyword DESC, which is identical to DESCRIBE one.

How do you view the table structure?

To show table properties in the Properties window1In Object Explorer, select the table for which you want to show properties.2Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.

Expert · Answer