Visualizing the SQL

Visualizing the generated SQL

To visualize generated SQL, the commands shown in Figure 73 are used.

Figure 73. Visualizing the SQL file

Steps:

1. Right-click on the "SQL" generation work product.

2. Run the "MDACs/SQL Designer/Visualize creation file" commands from the context menu that appears.

The "alter" file can also be visualized using the "Visualize creation file" command.

The "Visualize delete file" and "Visualize old delete file" commands are used to visualize the delete file and the delete file from a previous generation. This file only exists if the "Keep old delete file" parameter is active.

Generated SQL

The "Editing the generated file" window (as shown in Figure 74) is used to visualize the element's generated SQL file.

Figure 74. SQL generated for the "MPD_Library" package