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

Name the different types of indexes in sql and define them.

570


How many sql statements are used? Define them.

576


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1688


What is pl/sql language case sensitive?

635


What is bind reference and how can it be created?

582






what is error ora-03113: end-of-file on communication channel?

607


Can variables be used in sql statements?

554


How many developers work on postgresql?

568


what is a primary key? : Sql dba

556


what is sql? : Sql dba

557


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

559


Can we commit inside a trigger?

549


Why does sql need a server?

565


What are the different types of triggers?

595


What is oracle and pl sql?

663