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

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

Question Posted / tejas wajge

Answer Posted / tejas wajge

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is user defined functions? : Sql dba

1039

What is the purpose of a secondary key?

979

How can I see all tables in sql?

1083

What is cte?

986

How do I run a script in sql developer?

956

what are the differences among rownum, rank and dense_rank? : Sql dba

1045

what are the authentication modes in sql server? : Sql dba

1073

What does a pl/sql package consist of?

981

What is t-sql? : Transact sql

996

How do rank () and dense_rank () differ?

1052

Can we commit in trigger?

987

What is sap sql anywhere?

1091

define data blocks ? : Sql dba

1002

What are the disadvantages of file system?

1273

what is index? : Sql dba

1010