How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 11281 Views
- I also Faced
- E-Mail Answers
Answer Posted / anji
create table table_name as ( select * from old_table where 1=2)
from this query we can create a new table structure from old
table structure with out data
| Is This Answer Correct ? | 26 Yes | 1 No |
Post New Answer View All Answers
Can we create a trigger on view?
What is the use of index in sql?
how to get a list of all tables in a database? : Sql dba
how to drop an existing view in mysql? : Sql dba
Compare sql & pl/sql
How will you distinguish a global variable with a local variable in pl/sql?
Which join is like inner join?
what are the type of locks ? : Sql dba
How do you define a foreign key?
Enlist the characteristics of pl/sql?
explain the difference between delete , truncate and drop commands? : Sql dba
Does asenumerable execute the query?
what is a control file ? : Sql dba
How many clustered indexes can be created on a table?
Can we join same table in sql?
