Object Inspector helpUse the object inspector to view Tables, Views and Stored Procedures on your database. SQL keywords are colored red, column and variable references are colored green while strings and comments are colored brown. Tables are highlighted with a hypertext link which can be used to navigate between objects. In JDBC Triggers and Defaults are included under the list of Stored Procedures.To edit a stored procedure or view click on the "edit" link at the top of the page and a HTML form based editor will open allowing you to make changes to the object. Press the "Save" button to save the changes to the database. If there are any errors these will be inserted into the object source just before the line they occur prefixed by a number of exclamation marks ("!"). Resolve the error and save again and these error markers will be removed. Click on the "Back" button when you are finished editing. The "resolve" link views the objects with column data types resolved such that hovering over the source will show the table and type of columns referenced. For tables and views, the "refs" link will take a few seconds to parse the SQL source of a Sybase database for references to the object which are presented as links. This can be handy when trying to work out areas of code which modify data in a particular column. The "data" link will view the first 1000 rows of data in the table. This data can be further filtered by placing a where clause (without the "where") in the text field provided. |