Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table?
At present the only way I can think of is to restore a backup to another server and just delete records (a legacy database with data hitting over 12GB, might take some time) - but there's gotta be an easier way to do it...
