Project DescriptionSQL Dependency Refresher is a simple program to generate 'drop and create' statements for dependent views, procedures and functions of the selected DB tables.
This program can be used to quickly find most (if not all) of the objects dependent on a database table and generate 'drop and create' scripts for those objects.
This can be used to find and
quickly fix views, procedures, triggers and functions broken by changes to a database table.
Once the script is generated, it will be opened in the default text editor - where it can be transferred to SQL management studio for inspection, fixes, and running.
NOTE: edit the app.config file to specify the connection settings for the application to use.
Generate script for objects dependent on Sales.CustomerClick link to view output:
Sample output