CloudDM 4.8.0 adds GreptimeDB as a DataSource
Skip to main content

Retrieve and generate DDL

Use the object list in the left pane of Data Query to open a dialog where you can retrieve DDL for an existing object or generate DDL.

Retrieve DDL​

  1. Open Data Query and find the target table in the object list on the left.
  2. Right-click the table and choose Get DDL statement.
  3. In the dialog, select Get DDL statement.
  4. Review the DDL. To reuse the statement, click Copy SQL.
  5. Click Close to exit the dialog.

Generate DDL​

In the same dialog, choose Generate DDL statements and follow the prompts to configure the object definition and generate SQL. Review the target database, object name, and definition before copying or running the SQL.

info

The DDL syntax and available fields depend on the current DataSource type.