Database Discussion - copy table skeleton

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