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

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)