Common use of Button Description Clause in Contracts

Button Description. Preview Preview the data of the view. Explain Show the Query Plan of the view. View Builder Build the view visually. It allows you to create and edit views without knowledge of SQL. See SQL Builder for details. Beautify SQL Format the codes with the Beautify SQL settings in Editor. Hint: You can choose to show the preview results below the editor or in a new tab by choosing View -> Result -> Show Below Editor or Show in New Page. When you open a view, View Viewer displays data as a grid. Data can be displayed in two modes: Grid View and Form View. See Data Viewer for details. Materialized Views‌ Materialized Views are schema objects that used to summarize, compute, replicate, and distribute data. In the main window, click Materialized View to open the materialized view object list. You can create a materialized view shortcut by right-clicking a materialized view in the Objects tab and select Create Open Materialized View Shortcut from the pop-up menu. This option is used to provide a convenient way for you to open your materialized view directly without activating the Navicat main window. To refresh a materialized view, right-click it in the Objects tab and select Refresh Materialized View from the pop-up menu. Materialized View Designer is the basic Navicat tool for working with materialized views. You can edit the view definition as SQL statement (SELECT statement it implements) in the Definition tab. To customize the view of the editor and find out more features for SQL editing, see SQL Editor for details. If you want to load SQL statement from a SQL file to the editor, you can choose File -> Import SQL. Preview Preview the data of the materialized view. Explain Show the Query Plan of the materialized view. View Builder Build the materialized view visually. It allows you to create and edit materialized views without knowledge of SQL. See SQL Builder for details. Beautify SQL Format the codes with the Beautify SQL settings in Editor. Hint: You can choose to show the preview results below the editor or in a new tab by choosing View -> Result -> Show Below Editor or Show in New Page. When you open a materialized view, Materialized View Viewer displays data as a grid. Data can be displayed in two modes: Grid View and Form View. See Data Viewer for details. Procedures / Functions‌ Procedures and functions are schema objects that consist a set of SQL statements and stored in the server. In the main window, click Function to open the function object list. Click New Function from the object toolbar. Function Wizard will pop up and it allows you to create a procedure/function easily.