Pasting DDL in SQL Server 2000

Discover what the Paste command actually does in SQL Server 2000.

Brian Moran

May 21, 2002

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like