How to create Table Scripts

Database

How to create Table Scripts

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.

Thanks & regards,
Rami reddy.G
1 REPLY
Enthusiast

Re: How to create Table Scripts

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