[Resolved] returning SQL required to create table

[PurpleMonkey]

Hello.

I was wondering if it is possible in MySQL to return the SQL required to create a table I have in my database. This would be usefull for me as it would save alot of time.

Thanks in advance.

[sfullman]

SHOW CREATE TABLE _aux_countries

This will also show the indexes, and, I believe, any referential integrity you have set up.

[PurpleMonkey]

Wow thanks, thats exactly what I wanted.