How to Show Table Structure in MySQL


How to display structure of a table in MySQL:
- Structure of a table means list of columns (or fields) available in the table and their definition
- To display structure of a table; we take help of show columns command

Basic Syntax:
show columns from tablename;

show columns from tbl_student;

Interview Questions: