How do you create a table with an existing structure of another table with data and with no data?
- 1 Answers
- 856 Views
- I also Faced
- E-Mail Answers
Answer / praveen kota
Create table tablename as existing tablename with (no) data
| Is This Answer Correct ? | 0 Yes | 0 No |
If RDBMS is halted what will you do ?
Explain the term 'tables' related to relational database management system?
How many types of joins are there in teradata?
Why does varchar occupy 2 extra bytes?
What is meant by a Channel Driver?
What is the primary index in teradata?
What is the use of virtual processor connectivity in teradata?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
Why Fload doesn’t support multiset table?
where we can use the delimiter in mload? pls let me know
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
What do you mean by ttu in teradata?
Teradata 
