Displaying Object Definitions
Use the following procedures to display the text (the DDL or data definition language) used to create a table, view, macro or stored procedure in the Database Explorer Tree. The resulting text appears in the Answerset or Query window depending on which procedure you use.
To display the text used to create an object in the Answerset window
✔ Right-click on the object, then select Show Definition.
Abort the data retrieval process at any time by clicking the Abort icon on the toolbar. The results appear in the Answerset window.
Definitions are available as follows:
Column information only for most other vendors
Note: The definition for a Function or Procedure might not always be available.
To display the text used to create an object in the Query window
✔ Right-click on the object, then select Generate SQL>Create.
Abort the data retrieval process at any time by clicking the Abort icon on the toolbar. The results appear in the Query window.
Definitions are available as follows:
Column information only for most other vendors
Note: The definition for a Function or Procedure might not always be available.