Working with Common SQL Objects
Some SQL objects are dealt with commonly. As a convenience for you, PCC shows the following objects in PSQL Explorer and provides commands for their creation and editing:
•
Triggers
•
Stored procedures
•
User-defined functions
•
Views
When you use commands to create one of these objects, SQL Editor provides SQL syntax for that object to help you get started. For example, if you choose to create a new view, SQL Editor contains the syntax CREATE VIEW <viewname> AS.
*Tip: You can hover the mouse cursor on a SQL statement to obtain a tool tip on the syntax, which also includes an example.
SQL Editor provides the newly created object with a default name of object_n, where object is the name of the object and n is an integer that starts with one and increments by one. For example, if you create a new view, SQL Editor contains a new tab named “View_1.” After you save the object with a name of your choice, the tab reflects the saved name.
The following table defines the common objects and refers you to SQL Engine Reference for additional information.
Table 14
Description of Common SQL Objects in PCC
Object
Description
Related Information
Triggers
A type of stored procedure that are automatically executed when data in a table is modified with an INSERT, UPDATE, or DELETE.
CREATE TRIGGER in SQL Engine Reference
Common SQL Object Tasks
Stored procedures
A collection of one or more SQL statements that can take and return user-supplied parameters.
CREATE PROCEDURE in SQL Engine Reference
Common SQL Object Tasks
User-defined functions
A scalar routine that returns a value.
CREATE FUNCTION in SQL Engine Reference
Common SQL Object Tasks
Views
A database object that stores a query and behaves like a table.
CREATE VIEW in SQL Engine Reference
Common SQL Object Tasks