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
- 13176 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
Is sql workbench free?
Write the alter statement to enable all the triggers on the t.students table.
What is the example of procedure?
Is sql better than excel?
Which table is left in join?
which tcp/ip port does sql server run on? : Sql dba
What is exit statement?
explain normalization concept? : Sql dba
What is the use of sql trace?
Can you do multiple joins in sql?
What is a system versioned table?
What is PL/SQL Records?
Can delete statement be rollbacked?
How is a process of pl/sql compiled?
What is interval partition?
