Viewing Table Structure

To view the structure of a table, use the DESCRIBE statement or the SHOW COLUMNS statement:

Syntax:

DESCRIBE table_name;

Example:

DESCRIBE employees;

This shows the column names, data types, nullability, and other attributes of the employees table.