Hi, Any one please tell me how to create table script for existing tables in DB (automatically not manually). And I want to insert the data also. Please let me know. i am using SQL assistant tool for access the DB.
--Please direct the output of the below SQL to a bteq script and execute the same. select ' show table ' || trim(both from databasename) || '.' || trim(both from tablename) || ';' as tabledefn from dbc.tables where databasename = 'your database name'