PowerDesigner can generate sophisticated SQL scripts as files or for direct execution via a live database connection.
Advanced users can further customize database generation by, for example, changing the order in which objects are generated, adding scripts to run before or after generation, and generating additional objects. For information about these and other advanced topics, see Customizing and Extending PowerDesigner > DBMS Definition Files.