You can get the create statement several ways. Once is to use the SHOW CREATE TABLE statement like so show create table foo; On Friday, March 1, 2002, at 08:09 AM, rudy wrote: > show us the create table statement (i think there's a way you can pull > this > out using some script or admin front end app)