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
- 13471 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
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is the source code of a program?
what is meant by urlencode and urldocode? : Sql dba
what is foreign key? : Sql dba
What is column?
How is a process of pl/sql compiled?
I need a function for a train ticket reservation please answer it thanks in advance
what is bcp? When does it used? : Sql dba
How do you create a unique index?
Is sql a backend?
What is interval partition?
What is a recursive stored procedure?
How to revise and re-run the last sql command?
What is the difference between microsoft sql and mysql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
