Database/Diagram based, table based, procedure based, and view based SQL script support. One multiline text edit for each of them (one for database or diagram, one for each table, one for each procedure, one for each view) for writing user SQL script.
These SQL scripts should be generated either completely separately in a separate SQL file or in the same SQL file after the relevant object has been created. But Database/Diagram based before any object is created.
For example:
- Database/Diagram based (before) - SQL script for create database, for create logins, users, schemas etc.
- Table based (after) - SQL script for permission setting, insert some initial data etc.
- Procedure and view based (after) - SQL script for permission setting