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 SQL Editor Tasks .

These objects appear as nodes in the Pervasive.SQL 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