Friday, October 24, 2014

what the ways to generate DDL of various objects in NPS?


 nz_get_view_definition
Usage:    nz_get_view_definition  <database>  <view>

Purpose:  Display the definition (the SQL) that the view will execute.
nz_ddl*                              
nz_ddl_aggregate*           
nz_ddl_comment*            
nz_ddl_database* 
nz_ddl_diff* 
nz_ddl_ext_table* 
nz_ddl_function*  
nz_ddl_grant_group* 
nz_ddl_grant_user*
nz_ddl_group*  
nz_ddl_history_config*
nz_ddl_library* 
nz_ddl_mview* 
nz_ddl_object*  
nz_ddl_owner*
nz_ddl_procedure*
nz_ddl_security*  



No comments:

Post a Comment