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
- 13102 Views
- I also Faced
- E-Mail Answers
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
Is a foreign key always unique?
How do sql databases work?
What is a clob in sql?
What is transaction control language (tcl)?
How to run sql commands in sql*plus?
What is the difference between clustered and non-clustered indexes?
What does the file extension accdb stand for?
What is dense_rank in sql?
What is rownum in sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is dba in sql? : SQL DBA
how can we repair a mysql table? : Sql dba
How delete all records from table in sql?
Why stored procedure is better than query?
What are sql commands?
