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 the mutating table and constraining table?
Why stored procedure is faster than query?
what is sub-query? : Transact sql
What is the difference between local variables and global variables?
Can we use threading in pl/sql?
What is data manipulation language?
Does pl/sql support create command?
How do I make sql search faster?
How do I create a sql script?
how to use myisamchk to check or repair myisam tables? : Sql dba
what are the types of join and explain each? : Sql dba
what is table? : Sql dba
What is the left table in sql?
How do I delete a trigger?
Why do we use procedures?