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
- 12860 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 java sql drivermanager?
How do you create an update query?
Explain how to use transactions efficiently : transact sql
What is the difference between a subquery and a join?
What is a column in a table?
What is sqlerrd?
What is the difference between left outer join and left join?
What is a subquery in sql?
differentiate between float and double. : Sql dba
What sql database should I use?
Define concurrency control. : Transact sql
Does sqlite need a server?
Explain cursor types?
What kind of join is join?
What is hibernate and its relation to sql?
