Rule for Stored Procedures

  1. Procedures should be named PROC_<procedure_name>

Rule for Triggers

  1. Triggers must be named TR<type>_<table name>_<seq> where <type> is ‘I’, ‘U’ or ‘D’ and <table_name> is truncated to 24 characters. (‘I’ represents Insert; ‘U’ represents Update; and ‘D’ represents a delete).