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

What are the different softwares used with their functions in teradata?

660


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

639


What is the use of stored procedures in teradata?

659


What do you mean by teradata sql assistant?

673


Did you write stored procedures in teradata?

708






What do you mean by teradata intelliflex?

711


How do you create tables? Exact syntax, and create profiles, users in teradata?

653


how can we analyze the locks ?

1779


Mention a few of the ETL tools that come under Teradata.

717


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

766


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

2446


What can be achieved by using the teradata rdbms?

705


Name the five phases that come under MultiLoad Utility.

667


How is the teradata different from oracle?

712


What is the difference between union and union all in teradata?

716