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
Does pl sql work in mysql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is right join in sql?
How to run sql*plus commands in sql developer?
How to get help at the sql prompt?
Explain the working of foreign key?
what are the authentication modes in sql server? : Sql dba
What is mutating sql table?
What is difference between sql function and stored procedure?
How do I truncate a word?
How many times can we commit in a loop?
what are enums used for in mysql? : Sql dba
what is dbms? : Sql dba
What is where clause in sql?
what is csv? : Sql dba