How can I create a table from another table without copying
any values from the old table?
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 rollback? : Sql dba
Why schema is used in sql?
What are the uses of merge?
What are all different types of collation sensitivity?
What is composite data type in pl sql?
How do you optimize a stored procedure in sql?
Is it possible to sort a column using a column alias?
Is sql database free?
what are the differences between char and nchar? : Sql dba
How to display the records between two range in Oracle SQL Plus?
what is data manipulation language? : Sql dba
How do I view a sql trace file?
What are sql constraints?
what is 'mysqladmin' in mysql? : Sql dba
Where is pl sql used?