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
- 13229 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 many types of sql are there?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is the use of prepared statement?
What is not null in sql?
what are ddl statements in mysql? : Sql dba
What are the qualities of 2nf?
What is native sql query?
What is a behavioral trigger?
Why do we use sql constraints?
Mention what are different methods to trace the pl/sql code?
What are procedures used for?
What is the difference between an inner join and an outer join?
what are all the common sql function? : Sql dba
What is set serveroutput on?
How to sort the rows in sql.
