SHOW CREATE TABLE provides exact table structure

http://dev.mysql.com/doc/refman/5.0/en/show-create-table.html
+ Indexes
+ Default values
- Error on empty primary index