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

Discuss the advantages of using partitioned primary index in a query?

729


What is called partitioned primary index (ppi)?

754


What is the syntax for case when statement?

813


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4136


List out some of the primary characteristics of teradata.

750


Differentiate primary key and partition key?

756


Explain BYNET.

781


What is teradata and why it is used?

790


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

841


Which is faster fastload or multiload?

815


Explain the parallel data extension in teradata?

842


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

807


Name the five phases that come under MultiLoad Utility.

767


Explain PDE.

838


how many modules are there in telecome domain?how to explain the architecture?

1779