We have SQL Enterprise Manager (8.0). Is there any way to Copy a Table from one database to another with only the Structure (design) - not all the Data?
I can't find any option in the Import Data Wizard that only copies the Table structure.
Any help is appreciated. Thanks
You can generate script for the table and compile it on the target server. Right click on the table in EM, All Tasks -> Generate SQL Script...
No comments:
Post a Comment