Database Object Scripting Helpers

Table CRUD (Create, Update and Delete stored procedures) Generation

PragmaSQL can generate create, update, delete, list all and list single stored procedures (CRUD procedures) for you automatically. This feature can be a real time saver if you heavily develop client/server database applications. Simply you select the table from the Object Explorer and open the popup menu by right clicking on that node and find the “Script” sub menu item in the popup. CRUD generator will try to neatly organize generated stored procedures by exploding the procedure names to different parts as prefix, group, table name and operation. You can edit all these parts to match your naming convention.

Scripting Database Objects

You can script database objects to a new script editor window, to a single file or to a folder with PragmaSQL. To perform object scripting navigate to the database in the Object Explorer window, right click on the database node and open the popup menu and click “Script Objects” menu item. You will be asked for the destination (window, file, folder) , object types and object name filtering criteria. Press start and PragmaSQL will script the matching objects to the selected destination.