Hello, I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. So for example ...

It seems to do what we want as far as backing up a single table, however I tried copying back the data to a small table I set up to test the bcp command on, and it predictably just copies the data.