Pasting DDL in SQL Server 2000

In SQL Server 2000, I can right-click a table name and select Copy from the pop-up menu, but I can't paste. What's the Paste command actually doing?

Follow along with this example: Open Enterprise Manager and right-click to select the authors table from the Pubs database. Select Copy, then open Query Analyzer and choose Paste from the Edit menu. You've just pasted into Query Analyzer the Data Definition Language (DDL) code that creates the authors table. The Copy command doesn't affect data; it generates a DDL script and moves the results to your Clipboard. You can then paste the DDL script into a program that accepts Query Analyzer or Notepad text from the Clipboard.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.