StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><img src="https://i.stack.imgur.com/kHsVm.png" alt="PDM Model Options"></p> <p>Go to the Tools Menu</p> <p>Go to Model Options</p> <p>Under Category>Model Settings>Table & View</p> <p>Then you'll see Default owner on the right side.</p> <h2>Response to comment</h2> <p>PD is a great tool because it's very easy to try out simple cases. Follow these steps.</p> <ul> <li>Create a new PDM for PostGRES</li> <li>Add a table_1 (to it add columns_1, columns_2, columns_3)</li> <li>Add a new user called DBO (make sure to set the NAME and the CODE to DBO)</li> <li>Make the change I describe to the model options</li> <li>Add a table_2 (to it add columns_1, columns_2, columns_3)</li> </ul> <p>Now right click on the PDM in the browser pane and choose the preview tab.</p> <p>You'll see: <img src="https://i.stack.imgur.com/2huxl.gif" alt="this"></p> <p>Notice how the preview for table_2 has DBO. in front of the table name EXACTLY as you desire. I've also included in the screencap the screen for the List of Tables. You get to that via the Model menu. Notice how the owner is set to the DBO user for table_2, exactly like in the previewed DDL. If you go into the properties for table_1 or use this screen to change ALL of your tables en masse, all of your DDL will work the way you want. </p> <h2>XDB File</h2> <pre><code>create [%Temporary% ]table [%QUALIFIER%]%TABLE% ( %TABLDEFN% ) [%OPTIONS%] </code></pre> <p>Not sure what the %QUALIFIER% variable gets filled with but it seems to work.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload