To copy column definitions from one table to another You cannot copy individual columns from one table to another existing table by using Transact-SQL statements. However, you can create a new table ...

Sql Server Copy Tables and Views This python script is able to copy one or more tables (selected rows) or views from one sql server database/schema to another. If the tables already exist, it is able ...

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.