GENERATE_DDL_FOR_CATALOG

<< Click to Display Table of Contents >>

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

GENERATE_DDL_FOR_CATALOG

Previous pageReturn to chapter overviewNext page

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

5_2_indicator

Version 5.2 Feature

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

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