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
- 13238 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
What is multiple partition?
What is the file extension for sql database?
What is difference between table and view?
What are pl sql procedures?
What is informix sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Why do we use function in pl sql?
what are dynamic queries in t-sql? : Transact sql
Why do we use procedures in sql?
tell us something about heap tables. : Sql dba
explain what is mysql? : Sql dba
Why do we create views in sql?
What is before trigger?
Is oracle and sql same?
Why cross join is used?
