Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage

ROUTINES

Sundeck CATALOG.ROUTINES view stores information about routines.

Column NameData TypeDescription
NAMETEXTRoutine name
NAMESPACETEXTNamespace to which routine belongs to
REF_COUNTTEXTNumber of references (from broker and other routines) to this routine
CREATED_ATTEXTTime this routine was created at
LAST_MODIFIED_ATTEXTLast time routine was modified at.
DDLTEXTDDL to create this routine
COMMENTTEXTComments text

Example:

anshul@sundeck.io#COMPUTE_WH@SUNDECK.CATALOG>select name,ref_count from routines;
+--------------------+-----------+                                              
| NAME               | REF_COUNT |
|--------------------+-----------|
| Optimal Route      | 1         |
| Reject Bad Queries | 0         |
+--------------------+-----------+
2 Row(s) produced. Time Elapsed: 9.536s
anshul@sundeck.io#COMPUTE_WH@OPSCENTER.CATALOG>