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
- 13473 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
Do prepared statements prevent sql injection?
how to enter characters as hex numbers? : Sql dba
Why stored procedure is faster than query?
How do I create a sql script?
How does pl sql work?
List out the acid properties and explain?
how to use in conditions? : Sql dba
how do you know if your mysql server is alive? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is the purpose of using pl/sql?
How do I find duplicates in a single column in sql?
what does myisamchk do? : Sql dba
What is sql rowcount?
What are the topics in pl sql?
What is a table?
