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

Highlight a few of the important components of Teradata?

562


What is the opening step in basic teradata query script?

569


Why managing the data is important?

562


What are the joins in teradata and how many types of joins are there in teradata?

543


Differentiate database data and data warehouse data?

563






In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

556


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

1669


Difference between inner join and outer join?

557


How to eliminate product joins in a teradata sql query?

580


what is object level locking ? where do appear this type of locking ?

3084


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

4070


What is inner join and outer join?

590


Describe the set operators in teradata.

561


What are aggregate tables? How do you design them using teradata?

610


What are the different design perspectives used in teradata?

526