Interested to Buy Any Domain ? << Click Here >> for more details...
How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 13203 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh babu
create table new_tn as select * from source_tn where 1=2;
This query will create a new table,which take structure of
the source table with out values.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is left inner join in sql?
What are the two characteristics of a primary key?
What is difference between primary and secondary key?
What is dialect in sql?
Why partition by is used in sql?
What does bitemporal mean?
Is it possible to update views?
What is character functions?
What is PL/SQL Records?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is memory optimized?
how many tables will create when we create table, what are they? : Sql dba
What is sql rowcount?
what is dbms? : Sql dba
Can we insert delete data in view?
