title: How do I make a copy of a table within SQL Server Enterprise Manager?
body: <p>This is one of those "I probably should know this, but I don't" questions. How do I make a copy of a table in Enterprise Manager? Not export the data into a different database, just make a copy of the table within the <em>same database</em>. At this point, I don't care whether the data comes with or not, but the table definition should definitely be duplicated.</p>
  
  <p>If I do Ctrl+C on a selected table and paste the results into a text editor, it gives me a Create Table statement that looks promising, but I can't for the life of me find any place to run that statement.</p>
  
  <p>Edit: note that I'm asking about <strong>SQL Server Enterprise Manager.</strong> This is NOT the same thing as "SQL Server Management Studio". There's no "New Query" button, neither in the top left corner nor anywhere else. In fact, the word 'query' does not occur anywhere in EM except on the Tools menu, and there it's a link to Query Analyzer.</p>