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 |
How to find duplicates in a table?
How to copy teradata scripts from ur remote desktop to server machine?
How can we check the version of Teradata that we are using currently?
What is the use of upsert command in teradata?
During the Display time, how is the sequence generated by Teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
What does Amp contain and what are all the operations that it performs?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is the basic syntax for teradata select statement?
Why teradata is used?
What are the different softwares used with their functions in teradata?