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?

740


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

1931


What is the purpose of joins in teradata and what are the available join types?

786


What is teradata and why it is used?

807


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

1682


what are the uses of fact table and dimension table in banking project?

4333


Why are oltp database designs not generally a good idea for a data warehouse?

833


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

763


Explain teradata architecture?

864


What are the various indexes in teradata? How to use them?

779


What is the use of stored procedures in teradata?

787


why use references rather than pointers in the public api, particularly for arguments which are modified?

779


What are the available primary index types?

942


Why teradata is used?

788


How is MLOAD Teradata Server restarted after execution?

923