On 5 Ott, 20:33, Smitty <marksmith...@hotmail.com> wrote:
> On Oct 5, 2:31 pm, "Martijn Tonies" <m.ton...@upscene.removethis.com>
> wrote:
>
>
>
>
>
> > > Hello everyone. I am brand new to mySQL, so I am not sure if this can
> > > be done. Is there a way to capture a schema? I am taking over a
> > > number of databases, and I'd like to get a better understanding of
> > > each database. Thanks in advance
>
> > What do you mean by "capture a schema"? Create a visual diagram from it?
>
> > Yes, there are tools that can do that for you, both free and commercial.
>
> > Ours is a commercial tool named Database Workbench, seewww.upscene.com
>
> > --
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> > MS SQL Server
> > Upscene Productionshttp://www.upscene.com
> > My thoughts:http://blog.upscene.com/martijn/
> > Database development questions? Check the forum!http://www.databasedevelopmentforum.com
>
> Sorry, I wasn't more clear. Yes, a visual diagram would be great. I
> am going to try the tool you mentioned. Thanks a lot.- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -

Another powerful one, free, will show all the DBMS details, including
OleDBSchemGUIDs
stored procedures, relations, types, etc.
http://www.datatime.eu/download.aspx

Create Connection > DatabaseExplorer > Reload structure etc ...

Enjoy!

-P