Displaying Object Definitions - SQL Assistant

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.

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:

Tables – Full definition for Teradata
Column information only for most other vendors

All other object types – availability varies by vendor

Note: The definition for a Function or Procedure might not always be available.

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:

Tables – Full definition for Teradata
Column information only for most other vendors

Other objects – Availability varies by vendor

Note: The definition for a Function or Procedure might not always be available.