showing the create table command

[sfullman]

Hi All,

I know I've asked this question a while back but can't find it in docs.

I already have a mysql table. I want to generate the original string which created it , i.e. CREATE TABLE thistable( .. etc. .. ). I thought it was

DESCRIBE CREATE TABLE thistable

but that's not it. If you know this you know this, thanks!!

Sam

[Drakla]

show create table tablename;