I've needed to Google this a couple times, so I'm sharing my Q/A.
SHOW INDEX FROM [tablename]
to just look at a tables layout from the cli. you would do
desc mytable
or
show table mytable