>Is there a way to make identical copy of a table. I used copy structure but it seems to leave out comments and default values for my huge table. Help appreciated
>
>
>Nick Patel
Nick,
Sylvain has given you the easy way to do this (Stonefield Database Toolkit). With that you buy it, you learn it, and it does the stuff for you.
If you want to do this yourself you need to write a bit of code. You can copy the structure of the table. Then you need to use the database and add table to it. Then you need to use DBGetProp() for every database property to read it from the source and use DBSetProp() to set the property in the new database.
I would bet that if you write the code once you have spent more money in your time than Stonefield costs.