GET_OBJECT_DDL

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

GET_OBJECT_DDL

Previous pageReturn to chapter overviewNext page

Returns DDL for named object

Syntax

GET_OBJECT_DDL(catalog_name,schema_name,object_name);

 

Returns DDL for named object where catalog_name is the name of the current catalog, schema_name is the name of the current schema and table_name is the name of the table or view for which you want to generate DDL.

5_2_indicator

Version 5.2 Feature

As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.

Example

SELECT * FROM TABLE(SYS_BOOT.MGMT.GET_OBJECT_DDL('LOCALDB', 'SALES', 'BIDS'));

'CHUNK_INDEX','DDL'

'0','CREATE OR REPLACE STREAM BIDS (

  "time" BIGINT,

  "ticker" VARCHAR(5),

  "shares" INTEGER,

  "price" REAL,

  "expiryMs" BIGINT,

  "comment" VARCHAR(1024)

)'