Copy table data
You can duplicate the table data in the current schema or copy it to another schema or data source.
Create a copy of table data
Drag a table to the node in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.
Right-click a table and select Import <table_name> Table dialog, select the schema in which you want to create a copy, ensure that mappings are correct, and click Import.(F5). In the
In the data editor, click the Copy to Database… icon () and select a schema to which you want to copy the table.
Check the video at youtube.com to see the live example.
Copy table structure
You can copy the table structure using SQL Generator. To do that, in the Database Explorer ( ), right-click the table and select . Alternatively, press Ctrl+Alt+G.
For information about the SQL Generator… controls, see Generate DDL definitions for database objects.