Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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...
|
|||||||
03-28-2008
|
|||
|
|||
|
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 |
|
03-28-2008
|
|||
|
|||
|
Re: Copy table without data
create table table_name as select * from table_name where 1=2;
|
|
04-25-2008
|
|||
|
|||
|
Re: Copy table without data
select * into [New tab-name] from [old tab-name]
hope this will helpfull.............
|
|
04-25-2008
|
|||
|
|||
|
Re: Copy table without data
CREATE TABLE table_name2 as select * from table_name1 where 1=0
|
|
04-28-2008
|
|||
|
|||
|
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.
|
|
05-04-2008
|
|||
|
|||
Re: Copy table without data
Quote:
Need not worry to much for such issues .have pepsi and enjoy life 
|
|
11-11-2008
|
|||
|
|||
|
Re: Copy table without data
Quote:
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear 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 07:58 PM.
