GET_OBJECT_DDL

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.

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)
)'