Selecting Database Objects
Applies to: Kyvos Reporting
In SQL Designer, you can select database (schema) objects such as procedures, synonyms, tables, and views by using the available radio buttons.
Once selected, a list of corresponding object names appears in the adjacent list pane. You can drag the required objects from the list and drop them into the Diagram Pane.
Multiple Selection Methods
You can select multiple objects using the following methods:
Press Ctrl and click to select non-contiguous entries.
Press Shift and click to select a continuous range.
Click and drag to select individual entries.
Important
Before using a stored procedure, ensure that it does not perform any unintended data manipulation in the connected data source.
Note
For semantic model connections, the Design, Filters, Sort, and Stored Proc. tabs in the SQL Parser pane are not available. Use the Edit tab to manually write your query.
Removing Tables from SQL Designer
To remove a table from the SQL Designer layout:
Right-click the table in the Diagram Pane.
Select Delete Table from the context menu.
If the table is part of a defined join, delete the join relationship before removing the table.