Re-create existing Tables in new DB
Posted on 1997-12-23
I want to recreate ALL full tables as empty tables
from one database into a new database. These tables DO NOT exist in the new database. There are 400 of them and I don't want to create them manually. The defncopy and bcp utilities don't help here, as I want to create the tables then run these utilities on the database afterwards.
I want to re-create an exact replica of the database in
a smaller version of it, for use at home where I haven't
got the disk space.
This is not an easy one but the only points
I got left are 62.45pts.
P.S. If in your opinion it can't be done. Please do not supply it as an answer, but as a comment. You never know there might be a way of doing this (i've got part of the
way using a script that I wrote)? then that would leave the question unlocked for the others to see instantly.