How to Show Table Structure in MySQL
Notes:
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;
Ex:
show columns from tbl_student;
Interview Questions:
