Print Page | Close Window

copy table skeleton

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21081
Printed Date: 28 March 2026 at 7:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: copy table skeleton
Posted By: zMaestro
Subject: copy table skeleton
Date Posted: 19 August 2006 at 8:16pm
How can I copy a table skeleton? I have a table in MsSQL I want to create another one (an image from it) but without any data, How can this be done?
 
Thanks.



Replies:
Posted By: dfrancis
Date Posted: 19 August 2006 at 9:50pm
In Enterprise manager, right click over the table and select "all tasks" and then "generate SQL script" Another dialog will come up and you can select the options but just for the table, click preview and there it is.


Posted By: zMaestro
Date Posted: 20 August 2006 at 1:12am
emm.. i got this error

Warning: The table 'PressX' has been created but its maximum row size (38963) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.


Posted By: michael
Date Posted: 20 August 2006 at 1:22am
That has to do with the structure of the table. You may be able to ignore that but better off fixing it in the script...

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net