Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

Explain the term 'database' related to relational database management system?

195


Which is more efficient group by or distinct to find duplicates?

224


What are the uses of bynets in multi-node systems?

204


What do you mean by teradata intellicloud?

222


What are the different design perspectives used in teradata?

195






Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1278


Describe primary index in teradata. And what are the available primary index types?

209


Highlight the limitations of TPUMP Utility.

208


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1342


how can we analyze the locks ?

1278


What is stored procedure in teradata?

216


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1548


What are the different functions performed in development phase?

222


Differentiate database data and data warehouse data?

231


What are default access rights in teradata? What explicit right can be given to a user?

218