How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 11280 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
In oracle
Create table newtablename as select * from oldtablename
where 1=2
(any false condition if condition true it copies data from
table it applicable for both oracle & sqlserver)
In Sql server
select * into newtablename from oldtablename where 1=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between inner join and outer join?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what is msql? : Sql dba
What are different types of triggers?
What is rtm in testing?
how to do backup entire database? : Transact sql
What is the difference between an inner and outer join?
What are all the ddl commands?
What are stored procedures in mysql?
How would you convert date into julian date format?
What are the types of optimization?
What are functions in sql?
Explain what is sql?
Can you selectively load only those records that you need? : aql loader
What does the file extension accdb stand for?
