GENERATE_DDL_FOR_CATALOG

Generates the DDL used to create everything in the current catalog.

Syntax

SELECT * FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_CATALOG());

Example

SELECT * FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_CATALOG());

'STATEMENT'
'CREATE OR REPLACE ROLE PUBLIC;'
''
'CREATE OR REPLACE USER _SYSTEM'
'AUTHORIZATION 'Unused';'
''
'CREATE OR REPLACE USER "sa"'
'AUTHORIZATION 'Unused';'