Is there any way to generate a table structure in an sql script?
This would be like the sql scripts to generate databases and tables initially.
Yes, there is, since CREATE TABLE ... etc ... can be a valid query.
Maybe I was not clear.
I want to generate a database structure from an existing DB to the sql script. The reverse of generating the DB and Tables from a script.
I found out how.
Just used phpMyAdmin...
Problem solved.
that should also be possible, since it should be possible to find out the column info and create a new table based on those.
phpMyAdmin allows you to export the structure of the entire DB or one table. If you want you can export the associated data.
