GENERATE_DDL_FOR_USER

<< Click to Display Table of Contents >>

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

GENERATE_DDL_FOR_USER

Previous pageReturn to chapter overviewNext page

Generates DDL for named user.

Syntax:

SYS_BOOT.MGMT.GENERATE_DDL_FOR_USER(user_name);

 

where <user_name> is the name of the user for which you want to generate DDL.

You can implement this function using the following code:

SELECT STATEMENT FROM

 TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_USER('MY_USER'));

 

5_2_indicator

Version 5.2 Feature

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