I'm in Visual Studio, Server Explorer, and I've attached to the SQL server. I go to tables and right-click on a specific table, select copy.
From here I want to be able create a copy of the table. I've clicked around a bit, Googled etc. but I haven't found an option to paste or create a new table this way.
Is this possible or am I just missing the mark here? We have some failry complex tables that are already setup the way I need, and we also have a number of tables that need to be moved from an older SQL 2005 server.
I am not that versed in SQL commands, so I was hoping this would be a viable option.
Thanks in advance!!