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

Explain the new features of teradata?

799


What is the multi-insert?

802


Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

955


What do high confidence, low confidence and no confidence mean in explain plan?

812


What do you mean by ttu in teradata?

749


Is multi insert ansi standard?

1952


Steps to create a data model?

876


What are the uses of bynets in multi-node systems?

794


any one answer me how they can analyzing the project using data ware housing?

2229


How many tables can you join in v2r5?

821


How many types of joins are there in teradata?

732


What is the difference between fastload and multiload? Which one is faster?

887


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

914


if collect stats but it show low confidence why?

1435


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

750