Helper objects


You can download all the helper objects.

sqltopia_indexes
This function return query texts for drop, create, disable and enable all indexes in the current database.

sqltopia_triggers
This function return query texts for drop, create, disable and enable all trigger in the current database.

sqltopia_check_constraints
This function return query texts for drop, create, disable and enable all check constraints in the current database.

sqltopia_computed_columns
This function return query texts for drop and create all computed columns in the current database.

sqltopia_datatype_rules
This function return query texts for drop and create all datatype rules in the current database.

sqltopia_datatype_defaults
This function return query texts for drop and create all datatype defaults in the current database.

sqltopia_foreign_keys
This function return query texts for drop, create, disable and enable all foreign keys in the current database.

sqltopia_graphs
This function return graph identity for all columns in the current database.

sqltopia_hierarchy
This function return hierarchy for all columns in the current database.

sqltopia_retry
This procedure will execute and if necessary retry, the wanted query text.

atac_action
This table holds all valid query action codes and the internal sorting for query texts for sp_AlterColumn.

atac_queue
This table holds all statements that are to be processed for sp_AlterColumn.

atac_configuration
This table holds all configurations for sp_AlterColumn.

atac_inherit
This procedure will check and set current configurations for sp_AlterColumn.

atac_populate
This procedure will create all necessary query texts for sp_AlterColumn.

atac_process
This procedure will execute all query texts in atac_queue table for sp_AlterColumn.

atac_replenish
This procedure will find all remaining columns using configurations in atac_configurations for sp_AlterColumn.

atac_reset
This procedure will truncate tables atac_queue and atac_configurations for sp_AlterColumn.