Triggers, Stored Procedures, User-defined Functions, and Views
PCC provides a way to create, modify, and delete triggers, stored procedures, user-defined functions, and views. See also SQL Editor Tasks.
These objects appear as nodes in the PSQL Explorer.
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