Clone Table for SQL Server Professionals clone function allows you to create copy of selected table (schema and data) to same database.

This operation is required in the next case: you need to verify some idea against live (not generated) data. However, you cant modify an existing table: it contains critical data or integrity does not allow you to make changes.

This handy utility helps database developers, performance tuners and database administrators create a second copy of a table within seconds

Here are some key features of "Clone Table for SQL Server Professional":

· Easy to use wizard interface
· Copy none, all or selected (by WHERE clause) rows
· Optional Drop target table
· Create indexes related with target table
· Create primary key related with target table
· Copy or reset Identity values
· Copy text and image data (for Professional version only)
· Support project files
· Command line support (for Professional version only)


LOB/BLOB (large binary or text objects) operations in Professional edition.

Limitations:

· 10 rows or objects limitation