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 query syntax?
Can you join views in sql?
How do you update sql?
Which command is used to call a stored procedure?
How many aggregate functions are available there in sql?
Does a user_objects view have an entry for a trigger?
what is the difference between primary key and unique key? : Sql dba
What is the difference between microsoft sql and mysql?
Which one is better subquery or joins?
how to run 'mysql' commands from a batch file? : Sql dba
What is difference sql and mysql?
what is top in tsql? : Transact sql
What is the use of pl/sql table?
What are different clauses used in sql?
Is primary key is clustered index?