is there some UML tool where I can draw my database design and generate SQL scripts for creating my database?
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
I don't know what sort of SQL flavour you're using but you could try MySQL Workbench. It's cross platform and free (as in 'free speech' not as in 'free beer').
You can also try the online code-generation service MOLA::UMLtoDB that automatically generates a SQL DDL script to create the database corresponding to an input UML class diagram.
I can recommend Enterprise Architect from http://www.sparxsystems.com.au/
Yes, several CASE (computer-aided software engineering) tools exist that will do this. Microsoft Visio is one such.