Answer Posted / yuvaevergreen
Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can we collect statistics on table level?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is the purpose of joins in teradata and what are the available join types?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Which is faster fastload or multiload?
What is meant by a node?
What are the functions of a teradata dba?
Explain the term 'row' related to relational database management system?
Explain teradata utilities?
Why is the case expression used in teradata?
what is object level locking ? where do appear this type of locking ?
What are the various indexes in teradata?
Highlight a few of the important components of Teradata?
Why teradata is used?
What does Amp contain and what are all the operations that it performs?