Cool Tips‎ > ‎

Tables and Triggers

 

Title

Description

Applicability

 

Get Table Metadata

Multiple queries to return key facts about tables, including indexes, keys and dependent objects

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

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.


2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get Trigger Metadata

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

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get Columns Updated by Trigger


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

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 




Comments