8. Maintaining Databases : Retain Templates of Important Tables
 
Share this page                  
Retain Templates of Important Tables
A good practice is to periodically generate copy scripts for important tables and views. The copy.in scripts are useful if you need to recreate new, empty tables, or the entire database.
To generate copy scripts, use the unloaddb or copydb commands, or use the Generate copy.in and copy.out dialog in VDBA.