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
How many codd's rules are satisfied by teradata database?
What is real time and near real time data warehousing?
Explain the term 'primary key' related to relational database management system?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is a three-tier data warehouse?
What does sleep function does in fast load?
Explain the new features of teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
How to run a query in teradata?
What is TPD?
Explain teradata architecture?
How to identify ppi columns?
What is the use of virtual processor connectivity in teradata?
What is the maximum number of dml can be coded in a multiload script?