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.

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...