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

Are pl sql variables case sensitive?

1046

differentiate between float and double. : Sql dba

1057

What is a record in a database?

1062

What are the ways on commenting in a pl/sql code?

1134

how to shutdown mysql server? : Sql dba

1102

what is 'mysqldump'? : Sql dba

1108

What is sql key?

990

What is column?

991

What is right join in sql?

1090

What is field delimiter?

1048

What does a pl/sql package consist of?

976

how to select unique records from a table? : Sql dba

1112

What is the difference between function, procedure and package in pl/sql?

1261

List different type of expressions with the example.

935

what is the use of double ampersand (&&) in sql queries?

1176