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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to call a javascript function from pl sql?

554


What sql does db2 use?

533


What is the purpose of the sql select top clause?

542


What is a variable in sql?

507


How do you delete duplicates in sql query using rowid?

531






define data blocks ? : Sql dba

538


Can we edit a view in sql?

539


What is t sql used for?

545


Which software is used for pl sql programming?

513


What is example of database?

511


What are pl/sql cursor exceptions?

563


What is nosql db?

531


what are date and time functions in mysql? : Sql dba

528


What are the advantages of pl sql over sql?

536


How do I run a pl sql procedure in sql developer?

503