Jack Vamvas wrote:
> I'd like to create a database schema of an existing mysql db - I have
> access to phpMyAdmin .
>
> Is there way via sql statement to derive the (data types, foreign
> keys, ) of existing tables?

Just EXPORT the table's structures