Winan,

If you go into Sybase Central and unload the database, all the "create table" statements will be in a text file called reload.sql.

You can also run dbunload from the command window. Look in help for the switches.

>Dear Sybase Experts,
>
>I am using ASA 7.0, I have a database with more than 100 tables inside, is there any 3rd party tools that can help me to create a SQL statement of "CREATE TABLE blah blah blah" for each table in my DB . please advise
>
>Regards
>Winanjaya