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
|
|
|
|
|
|