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
- 13107 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
What is indexes?
Explain what is a column in a table?
What is the requirement of self-join?
How can triggers be used for the table auditing?
What is sql procedures and functions?
Cite the differences between execution of triggers and stored procedures?
How delete all data from table in sql?
What are different types of tables in sql?
Describe types of sql statements?
What type of join is sql join?
What is sqlcontext?
Explain constraints in sql?
What are pl sql procedures?
Do prepared statements prevent sql injection?
How do I run a script in sql developer?
