How do you Generate Sequence in Teradata?

Answer Posted / sridhar

using identity we can generate sequence
syntax:

generated always/by default as identity (start with <value> increment by <value> min<value> max<value> no cycle)..

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of joins are there in teradata?

547


What tools would you use for that?

571


What is collect statistics?

589


Explain the teradata primary index mechanics in detail with a diagram.

571


How to identify ppi columns?

659






Explain some differences between mpp and smp?

593


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2355


What are the advantages of teradata?

604


how do you manage the production space. what are the proactive methods you can take ?

1478


What is dimensional modeling?

595


What is the use of virtual processor connectivity in teradata?

572


How is the teradata different from oracle?

626


What are the available join types in teradata?

598


What is spool space?

607


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3003