Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

copy the Table Structure

This is a discussion on copy the Table Structure within the SQL Server forums, part of the Databases category; Hi I want to copy the structure & all constrains of one table into other table. There is any Direct query is there without using Sql Scirpt???...

Geeks Talk > Databases > SQL Server copy the Table Structure

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-11-2007

vcyogi Contributing Member   Join Date: Jun 2007 Location: Bangalore Posts: 32 Thanks: 3 Thanked 20 Times in 5 Posts

copy the Table Structure Hi I want to copy the structure & all constrains of one table into other table. There is any Direct query is there without using Sql Scirpt???

Sponsored Links

#2 (permalink)   06-16-2007

RyanJames Expert Member   Join Date: May 2006 Location: New York, USA Posts: 118 Thanks: 0 Thanked 6 Times in 4 Posts

Re: copy the Table Structure You have a function called as copy function in SQL server which you can use to copy the structure and all constrains of one table into other table. If you want to make a clone of the same table with structure, constraints and data you can make use of clone function available with SQL server.

#3 (permalink)   07-03-2007

ms_plz Junior Member   Join Date: Jul 2007 Location: india Posts: 5 Thanks: 0 Thanked 1 Time in 1 Post

Re: copy the Table Structure create table tablename 1 from select * from tablename2

#4 (permalink)   08-04-2007

sundharmail Junior Member   Join Date: Aug 2007 Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts

Re: copy the Table Structure Using INTO we can copy.. SELECT TOP 0 * INTO New_Table_Name From Old_Table_Name The Above query will come only the structure for the table.. If U want to copy with the data then remove the "Top 0 ".. SELECT * INTO New_Table_Name FROM Old_Table_Name

Geeks Talk > Databases > SQL Server

« Connection string of SQL Server for Informatica | how to take data in a one table from two different server ? »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query to find structure of a table	Geek_Guest	SQL	12	09-01-2008 11:12 PM
Creating a table by copying another table's structure	Allan Paul	Oracle	12	07-12-2007 07:53 AM
How a java table be brought to data table?	dhandhan	QTP	0	04-15-2007 06:14 AM
Silent Copy - copy your files with the convenience!	JobHelper	Geeks Lounge	0	04-05-2007 04:40 AM
Deep copy	janelyn	ASP.NET	1	08-03-2006 02:18 PM

All times are GMT -4. The time now is 01:34 PM.