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
Highlight a few of the important components of Teradata?
What is the opening step in basic teradata query script?
Why managing the data is important?
What are the joins in teradata and how many types of joins are there in teradata?
Differentiate database data and data warehouse data?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Difference between inner join and outer join?
How to eliminate product joins in a teradata sql query?
what is object level locking ? where do appear this type of locking ?
what are the uses of fact table and dimension table in banking project?
What is inner join and outer join?
Describe the set operators in teradata.
What are aggregate tables? How do you design them using teradata?
What are the different design perspectives used in teradata?