Answer Posted / kavitha nedigunta
create table new_table as select * from old_table;
EG:- create table emp1 as select * from emp;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
How delete a row in sql?
What is the difference between database trigger and stored procedure?
What are the basic sql commands?
What is a .db file?
what are all the common sql function? : Sql dba
How do you declare a user-defined exception?
Is microsoft sql free?
What are pl sql procedures?
Why is a primary key important?
What are all the ddl commands?
what is subquery? : Sql dba
What is the purpose of design view?
Can ddl statements be used in pl/sql?
Is sql a scripting language?
What are the syntax and use of the coalesce function?
