2
|
3
|
Click the database in the list for which you want the SQL document to apply, or ensure that the option None is check marked if the SQL document does not apply to a specific database.
|
4
|
Click OK.
|
2
|
3
|
For the desired database, expand the Tables node.
|
4
|
a.
|
3
|
Click OK.
|
Indicates whether the editor is in insert mode or overwrite mode for character input. The Insert key toggles the mode. Note that the cursor changes shape for each mode.
|
|
Note: If None is specified as the database context, then the text “No Database Selected” appears instead of the name of the computer and database. The commands to execute SQL statements are disabled if None is specified. See To set database context for an SQL query.
|
3
|
1
|
3
|
1
|
2
|
Click SQL Editor.
|
3
|
Select the desired choices for SQL Statement Separator.
|
a.
|
b.
|
1
|
a.
|
b.
|
1
|
a.
|
c.
|
a.
|
c.
|
1
|
1
|
To execute all statements in Outline view, right-click on the root node then click Execute All Statements.
|
2
|
If multiple statements are selected, right-click on one of the selected statements, then click Execute Selected Statements.
|
3
|
If a single statement is selected, perform one of the following actions:
|
a.
|
c.
|
1
|
Click the Grid cell that contains the value you want to change.
|
3
|
Move the cursor outside of the cell (for instance, press Tab or click outside of the cell).
|
2
|
Click in the Value cell for each Column Name and type the desired value.
|
3
|
Click Add.
|
4
|
Optionally, click Refresh Grid on Exit if you want the table data refreshed .
|
5
|
Click Close.
|
2
|
3
|
Click OK to confirm the deletion.
|
Scalar Function1 As Typed in Grid Cell
|
|||
|
|||
|
|||
|
|||
1 The names are case insensitive. NOW() and now() are equivalent. The parentheses are required. That is, NOW is invalid but NOW() is valid.
|
a.
|
b.
|
To select an entire row, right-click on any cell then click Copy Text or click .
|
1
|
Click on the Text view.
|
a.
|
b.
|
2
|
Right-click then click Copy.
|
1
|
In PCC Pervasive PSQL Explorer, expand the Engines node and the registered server nodes to display the available databases.
|
3
|
Click New then one of the following depending on the object that you want to create:
|
•
|
•
|
•
|
5
|
a.
|
Right-click, then click Delete.
|
b.
|
Press Delete.
|