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

how mysql optimizes distinct? : Sql dba

1072

What is the difference between rename and alias?

1336

What is a call statement? Explain with an example.

996

What is the difference between nvl function, ifnull function, and isnull function?

1101

How do you update sql?

963

What is the maximum size of sqlite database?

1101

What are the sql versions?

935

What is varchar sql?

1129

What is data type in database?

986

Is it possible to update views?

954

what is a field in a database ? : Sql dba

1051

Is sql a oracle?

969

Does postgresql run on the cloud?

1139

What can you do with pl sql?

1088

How many joins in sql?

997