How do you create a table with an existing structure of another table with data and with no data?
Answer / praveen kota
Create table tablename as existing tablename with (no) data
| Is This Answer Correct ? | 0 Yes | 0 No |
Why FLOAD does not support multiset tables??
What is the purpose of joins in teradata?
Explain the term 'columns' related to relational database management system?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
what are the default access rights in the teradata?
can we load 10 millions of records into target table by using tpump?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
Highlight the differences between Primary Key and Primary Index.
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
What is a three-tier data warehouse?
What is a sparse index?