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
- 12861 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 are the types of views in sql?
Why we use join in sql?
What do you understand by exception handling in pl/sql?
What is difference between ms sql and mysql?
Why truncate is faster than delete?
How to select all records from the table?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Which table is left in join?
What is foreign key sql?
How to rename a table?
difference between anonymous blocks and sub-programs.
Explain the advantages and disadvantages of stored procedure?
What is difference between nchar and nvarchar?
What is orm in sql?
How do we use distinct statement? What is its use?
