Use the describe command to display the table structure then use the crea

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

Question Posted / shabana

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Can pl sql procedure have a return statement?

997

what does the t-sql command ident_incr does? : Transact sql

1052

What is varchar example?

1010

What does <> sql mean?

1056

Explain locks? : Transact sql

985

What is indexing in sql and its types?

1055

Why is sql better than hql?

969

What is t sql used for?

1001

What is cursor status?

1174

What are the parts of a sql statement?

1072

What is an implicit commit?

1035

Can we edit a view in sql?

961

What is rownum and rowid?

1014

Is inner join faster than left join?

1168

What are the different tcl commands in sql?

1150