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
- 13474 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
Is pl sql better than sql?
Is sql a case sensitive language?
What happens when a trigger is associated to a view?
What is difference between stored procedures and application procedures?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Can unique keys be null?
What is the difference between left and left outer join?
What is a sql schema used for?
Does user triggers have entry for trigger with compilation errors?
What is a primary key? Explain
Is delete faster than truncate?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is sql and db2?
What is view explain with example?
Can we use insert statement in function?
