show table information

DESCRIBE table_name;
show Field from  table_name;
SHOW INDEX FROM table_name;