How can I create a table from another table without copying
any values from the old table?

Answers were Sorted based on User's Feedback



How can I create a table from another table without copying any values from the old table?..

Answer / anji

create table table_name as ( select * from old_table where 1=2)

from this query we can create a new table structure from old
table structure with out data

Is This Answer Correct ?    26 Yes 1 No

How can I create a table from another table without copying any values from the old table?..

Answer / suresh babu

create table new_tn as select * from source_tn where 1=2;

This query will create a new table,which take structure of
the source table with out values.

Is This Answer Correct ?    6 Yes 0 No

How can I create a table from another table without copying any values from the old table?..

Answer / tejas wajge

create table emp as select * from project where rownum <1;

Is This Answer Correct ?    4 Yes 0 No

How can I create a table from another table without copying any values from the old table?..

Answer / srinivas

create table emp1
as
select * from scott.emp where rownum=0

Is This Answer Correct ?    3 Yes 0 No

How can I create a table from another table without copying any values from the old table?..

Answer / atul verma

SELECT *
INTO emp1
from scott.emp where rownum=0

Is This Answer Correct ?    0 Yes 0 No

How can I create a table from another table without copying any values from the old table?..

Answer / ram

In oracle

Create table newtablename as select * from oldtablename
where 1=2
(any false condition if condition true it copies data from
table it applicable for both oracle & sqlserver)

In Sql server

select * into newtablename from oldtablename where 1=2

Is This Answer Correct ?    0 Yes 0 No

How can I create a table from another table without copying any values from the old table?..

Answer / sunil panghal

create table sunil as select *from hr.employees

Is This Answer Correct ?    0 Yes 2 No

How can I create a table from another table without copying any values from the old table?..

Answer / shabana

Use the describe command to display the table structure
then use the create table command and copy the table
structure in your command.

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

How do I order by ascending in sql?

0 Answers  


What are crud methods?

0 Answers  


What are two virtual tables available during database trigger execution ?

2 Answers  


What schema means?

0 Answers  


What is NOCOPY?

6 Answers   DELL,






Why do we need cursors in pl sql?

0 Answers  


How are functions and procedures called in PL/SQL?

0 Answers  


What are the differences between in and exists clause?

0 Answers  


what is denormalization. : Sql dba

0 Answers  


What is an intersect?

0 Answers  


How many types of normalization are there?

0 Answers  


How to find last day of the month in sql query

4 Answers  


Categories