Please note: The SQL Developer Bundle has been replaced by SQL Toobelt Essentials, it includes all the tools from the SQL Developer Bundle except for SQL Dependency Tracker, SQL Connect, SQL Packager, and SQL Refactor.
If you have a license for the SQL Developer Bundle, it will still work and except for SQL Connect, SQL Packager, and SQL Refactor, all the tools remain fully supported. If you have...
Show more
Please note: The SQL Developer Bundle has been replaced by SQL Toobelt Essentials, it includes all the tools from the SQL Developer Bundle except for SQL Dependency Tracker, SQL Connect, SQL Packager, and SQL Refactor.
If you have a license for the SQL Developer Bundle, it will still work and except for SQL Connect, SQL Packager, and SQL Refactor, all the tools remain fully supported. If you have Support & Upgrades you will still receive updates to them.
SQL Prompt finds invalid objects
Released: Feb 11, 2011
Updates in this release
Updates in V5.0
Find Invalid Objects SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.
Script Object as ALTER from a query window If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.
View column dependencies SQL Prompt 5 enables you to view a list of objects that reference a column.
SQL Refactor functionality SQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Professional Edition, including Smart Rename, Qualify Object Names, Expand Wildcards, Split Table, Encapsulate as New Stored Procedure, Find Unused Variables and Parameters, and Summarize Script.