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

What is the difference between delete, truncate and drop command?

1132

What is field delimiter?

1040

How many parts of a pl sql block are optional?

1116

What is t sql used for?

1009

Which is faster view or stored procedure?

936

Explain what is a field in a database and record in a database?

1087

Is null operator in sql?

1019

What is cartesian join in sql?

1107

How many databases can sql express handle?

976

How will you distinguish a global variable with a local variable in pl/sql?

1145

What are database links used for?

1036

how to get a list of columns in an existing table? : Sql dba

953

What are its different types of dbms?

996

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1088

Describe types of sql statements?

1052