what is identity column in TD?

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


Please Help Members By Posting Answers For Below Questions

Can we collect statistics on table level?

828


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1574


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

800


How would you load a very large file in teradata in general? What utility would you use for it? Why?

878


Which is faster fastload or multiload?

841


What is meant by a node?

836


What are the functions of a teradata dba?

835


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

745


Explain teradata utilities?

791


Why is the case expression used in teradata?

831


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

3329


What are the various indexes in teradata?

808


Highlight a few of the important components of Teradata?

820


Why teradata is used?

796


What does Amp contain and what are all the operations that it performs?

798