Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Copy Table Structure Without Data Using 1 Line Query Expand / Collapse
Author
Message
Posted Thursday, June 17, 2010 7:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 11:18 PM
Points: 3, Visits: 17
There is an issue held to copy table for this way .Key and identity are lost.Only use the query to use take Backup ony.
Post #938878
Posted Monday, June 28, 2010 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 12:28 PM
Points: 1, Visits: 98
is not this better?

SELECT TOP 0 * INTO [New_Table1] FROM [Table1]
GO
Post #944196
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse