[pilot-db-list] Copying database structure with views?

[Schweikert, M. {POYD~Kaiseraugst} <MAR...@Ro...>]

Hi!

I'm using DB to keep some kind of "logfiles" for various purposes (being able to sort by various columns is great!). For each year, I want these "logfiles" to be separate. So, at the end of the year I start a new "logfile" by copying the structure of the old one.

Unfortunately, the views (in detail: the widths of the fields) are not copied - I have to define them anew in the new database.

Is there a way to copy the structure of the database PLUS the widths of the fields in the views?

Best Regards / Mit freundlichem Gruss
Martin Schweikert
-- 
F. Hoffmann-La Roche Ltd.   Division Pharmaceuticals
IT Service Unit Basel       DOCUMENTUM Services
Department POYD-D           Bldg. 223 / Room 311
Phone +41 61 688 3188       Fax +41 61 687 2770