How to copy a table, with its data, in SQL Server (no, Mgt Studio doesn't do it for you)

You would really think that this would be a built-in feature available from the context menu.  But as proof it most definitely is NOT, see:

https://technet.microsoft.com/en-us/magazine/dd401720.aspx

As Microsoft tells you, just do this:

SELECT * INTO BizDev.CurrCustomers FROM Sales.Customers