Lists all triggers for a database.
Syntax
ESS_FUNC_M EssDisplayTriggers (hCtx, AppName, DbName, pszTrg, pCount, ppTriggerList);
| Parameter | Data Type | Description |
|---|---|---|
hCtx | ESS_HCTX_T | API context handle. |
AppName | ESS_STR_T | Application name. |
DbName | ESS_STR_T | database name |
pszTrg | ESS_STR_T | The name of the specific trigger to return information for. If pszTrg is "" (empty string), then all triggers in the specified database will be returned. |
pCount | ESS_PUSHORT_T | Address of the variable to receive the number of triggers for which information will be returned. |
ppTriggerList | ESS_PPTRIGGERINFO_T | Address of pointer to receive an allocated array of trigger information structures. The trigger information structure includes each trigger name, the trigger definition, and a boolean field indicating whether the trigger is enabled. |
Notes
The memory allocated for ppTriggerList should be freed using EssFree().
Return Value
If successful, returns the count of trigger in the database in pCount, and an array of trigger names in ppTriggerList.
Access
This function requires the caller to have database Design privilege (ESS_PRIV_DBDESIGN) for the specified database.
See Also