create database schema

28/10/2007, 11h47

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?

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com

28/10/2007, 13h31

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

28/10/2007, 11h47	#1
Jack Vamvas Messages: n/a Hébergeur:	create database schema 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? -- Jack Vamvas ___________________________________ Search IT jobs from multiple sources- http://www.ITjobfeed.com

28/10/2007, 13h31	#2
Paul Lautman Messages: n/a Hébergeur:	Re: create database schema 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

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email