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 difference sql and mysql?

936

How many databases can sql express handle?

939

Can we use pl sql in mysql?

959

what are all different types of collation sensitivity? : Sql dba

927

Describe different types of general function used in sql?

976

What is plpgsql language?

971

differentiate between float and double. : Sql dba

988

What is pls integer?

982

What is mutating sql table?

1038

What is meant by temporal data?

903

what are the difference between clustered and a non-clustered index? : Sql dba

976

What is a dynamic query?

968

How does a self join work?

986

Why should I use postgresql?

966

Is t sql a programming language?

1000