Tables and Triggers


Get Table Metadata - Multiple queries to return key facts about tables, including indexes, keys and dependent objects

Get Table Metadata (2) - 3 larger queries to produce lists of table attributes that are present/missing, plus one to produce a list of tables in dependency order for use in insert and delete statements.

Get Trigger Metadata - Multiple queries to return key facts about triggers, including counts, code and excessive size/number per table

Get Columns Updated by Trigger - Get a list of columns updated by a trigger. Only usable at run time within the trigger code