You can use SHOW CREATE TABLE for this.
Shows the CREATE TABLE statement that
creates the given table. The statement
requires the SELECT privilege for the
table. As of MySQL 5.0.1, this
statement also works with views.
E.g.:
SHOW CREATE TABLE MyTablename