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
- 13112 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
State few characteristics of pl/sql?
Can a commit statement be executed as part of a trigger?
How does postgresql compare to mysql?
What is a table in a database?
Is crud a cuss word?
What is the difference between count 1 and count (*) in a sql query?
Which is faster truncate or drop?
How delete all data from table in sql?
what is a trigger? : Sql dba
Write an sql query to select all records from the table?
Where is all the data on the internet stored?
How do I start sql from command line?
how do you know the version of your mysql server? : Sql dba
How do I start pl sql?
What are the datatypes available in pl/sql ?
