Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Copy table without data

This is a discussion on Copy table without data within the SQL forums, part of the Databases category; suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account...

Geeks Talk > Databases > SQL Copy table without data

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   03-28-2008

rahul.kgupta79 Junior Member   Join Date: Mar 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Copy table without data suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account

Sponsored Links

#2 (permalink)   03-28-2008

priyasp_msit Contributing Member   Join Date: Jul 2007 Posts: 43 Thanks: 1 Thanked 1 Time in 1 Post

Re: Copy table without data create table table_name as select * from table_name where 1=2;

#3 (permalink)   04-25-2008

ushalakshmi Junior Member   Join Date: Apr 2008 Location: visakhaptnam Posts: 18 Thanks: 2 Thanked 2 Times in 1 Post

Re: Copy table without data select * into [New tab-name] from [old tab-name] hope this will helpfull.............

#4 (permalink)   04-25-2008

ashalalaxmi2002 Contributing Member   Join Date: Sep 2007 Location: hyderabad Posts: 37 Thanks: 5 Thanked 2 Times in 2 Posts

Re: Copy table without data CREATE TABLE table_name2 as select * from table_name1 where 1=0

#5 (permalink)   04-28-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 126 Times in 113 Posts

Re: Copy table without data it is not necessary to give as 1=0 or 1=2 . In the where clause you can provide any condition which evalutes to false.

#6 (permalink)   05-03-2008

majidms7 Junior Member   Join Date: May 2008 Location: india Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Copy table without data we can give negative value also, for this we should have known what records that table contains.

#7 (permalink)   05-04-2008

ec0321 Junior Member   Join Date: Jan 2008 Location: Mumbai Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Copy table without data Quote: Originally Posted by rahul.kgupta79 suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account Need not worry to much for such issues .have pepsi and enjoy life

#8 (permalink)   3 Weeks Ago

krishna1986 Junior Member   Join Date: Nov 2008 Location: Kanpur Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Copy table without data Quote: Originally Posted by rahul.kgupta79 suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account you can use "paste special" option

Geeks Talk > Databases > SQL

« Kindly check if the answer is right | Update 2 fields in same record »

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
Copy data from word to excel	test123test	QTP	1	02-27-2008 08:06 AM
Copy Table	susarlasireesha	Oracle	6	11-05-2007 02:30 AM
How to insert data from one table to an empty table	sahanai mishra	Oracle Apps	1	08-11-2007 11:45 AM
copy the Table Structure	vcyogi	SQL Server	3	08-04-2007 02:43 AM
How a java table be brought to data table?	dhandhan	QTP	0	04-15-2007 06:14 AM

All times are GMT -4. The time now is 12:38 PM.