---With date from existing table to new table. SQL> create table new

How to copy a table in another table with datas?

Question Posted / raghunanda

9 Answers
13985 Views
I also Faced
E-Mail Answers

Answer Posted / raghunanda

---With date from existing table to new table.
SQL> create table new_table_name as select * from old_table_name where 1=1;
---without data
SQL> create table new_table_name as select * from old_table_name where 1=2;

Thanks,

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the use of set statement in tsql? : Transact sql

943

What is a unique key?

1004

What is compute?

1011

How to know the last executed procedure?

1032

what is a tablespace? : Sql dba

1005

What is primary key sql?

952

What is clustered index sql?

931

What are the syntax and use of the coalesce function?

1103

What is sql select statement?

969

What is the most restrictive isolation level? : Transact sql

1024

What is pls integer?

983

can a stored procedure call itself or recursive stored procedure? : Sql dba

956

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

942

What are all ddl commands?

1014

In a distributed database system, can we execute two queries simultaneously?

992