System table or stored procedure in Netezza to get create-table-sql of a table -


i need extract create-table-sql of table created in database in netezza, using query executed program. if there system table, stored procedure or otherwise, let's me that, please let me know. highly appreciated.

the create statements not saved in table, can query table structure system tables in database. start nformation_schema.columns:

select * information_schema.columns table_name='tablename' 

all information on create parameters stored in system tables tables.

dumping information table:

exec sp_help 'tablename' 

Comments

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -