You can have your stored procedures, functions and other pieces of code in your project. Object status feature offers you a method to verify whether the code you see in files is identical to the objects in your database (assuming you have specified the default connection in project properties).
You may need to verify if SQL of your stored procedures, functions and other objects stored in files in your project (*.fnc, *.prc and so on) is up to date.
Toad Extension helps you by checking the SQL code against existing database connection and shows you visually that an object is current, modified, missing or unknown.
- Current
- Modified
- Missing
- Unknown
You may need to update an object from the database. Then use the option Update from Database
Note that you can update several objects at once.