How can I create a table from another table without copying
any values from the old table?
Answer Posted / suresh babu
create table new_tn as select * from source_tn where 1=2;
This query will create a new table,which take structure of
the source table with out values.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is 'mysqlimport'? : Sql dba
How many types of cursors supported in pl/sql?
What are predefined functions in sql?
what are the different type of sql's statements ? : Sql dba
what is a unique key ? : Sql dba
What is the purpose of a secondary key?
what happens if you no create privilege in a database? : Sql dba
Which certification is best for sql?
Define concurrency control. : Transact sql
Explain the difference between rename and alias?
What is schema in sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
what is isam? : Sql dba
What is orm in sql?
Is drop table faster than truncate?