How can I create a table from another table without copying any values from th

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / star dba

8 Answers
13168 Views
I also Faced
E-Mail Answers

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