Script tables to emulate Copy in Enterprise Manage

This script will produce the same output as doing a Copy in enterprise manager and then pasting into Query Analyser.It can handle Clustered and Nonclustered Primary Keys, Multiple Foreign Keys, Defaults, Constraints, Identity Fields.  If you are able to improve this script, or find any bugs, please let me know.

2003-04-09

164 reads

Blogs

Behavior of numeric data types with ”

By

As we all know, there are various numeric data types, such as TINYINT, INT,...

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs

Forums

Question on report server database

By itmasterw 60042

Hi,   We just installed SQL Server 2019 on a new server and moved...

Disclosing the How

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Disclosing the How

Deprecated Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deprecated Features

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers