The Database Explorer displays detailed information about database objects including columns, indexes, keys, statistics, DDL, procedure text, and data from the tables.
To browse database objects
The left pane of the window displays database objects that relate to your user logon. The right pane displays information about a selected database object.
Note: Access to database objects depends on your database privileges.
In the left pane, expand the branches to select a database object.
Use the tabs at the bottom of the right pane to view information about the selected database object.
The Object Extractor extracts the DDL for creating database objects from the database. As an option, object dependencies can also be retrieved ordering them by the lowest dependencies first.
Select the objects to extract from the left pane [Select objects to be extracted]. Click Add to add the selected objects to the right pane [Objects to extract].
Click Extract DDL to display the DDL script on the bottom pane. Or, click Extract to file to save the DDL script directly to a file.
In the Extraction Criteria window, select options to generate the DDL script.
Extraction preferences can be changed by selecting File | Preferences and selecting the DDL tab.
The SQL Worksheet enables you to create and execute Transact-SQL code, database objects and SQL commands.
Enter your SQL statement or Transact-SQL code in the Editor pane.
Use the drop down field at the top of the Editor pane to review and reuse any code executed in the SQL Worksheet during your session.
The Code Finder identifies database objects and files that contain specific text.
Enter the text string to search for in the Text field in the Search Criteria section.
Use the Quick Find, Database Objects and Directory/Files tabs to select what to search. You can search in database objects (Tables, Views, Procedures, Triggers, Rules, Defaults, etc.) and/or files.
Double-click an item in the Search Result pane to open the matched database object or file in the SQL Worksheet.