Returns DDL for named object
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.
0: jdbc:sqlstream:sdp://drew-VirtualBox> 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)
)'
1 row selected (0.468 seconds)