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

Answer Posted / sunil panghal

create table sunil as select *from hr.employees

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a procedure and a function?

494


Can instead of triggers be used to fire once for each statement on a view?

541


What is sql character function?

546


How many postgresql users are there, worldwide?

580


List the ways to get the count of records in a table?

512






Mention what does plv msg allows you to do?

669


what are tables and fields? : Sql dba

582


What has stored procedures in sql?

603


explain what is mysql? : Sql dba

600


What is offset in sql query?

598


How do I add a database to sql?

584


What is t sql used for?

553


What found sql?

529


explain the difference between myisam static and myisam dynamic. : Sql dba

519


What is count * in sql?

558