what is identity columns in teradata

Answer Posted / yogi

Identity column is used in tables to get the unique
values.Values of the attribute is stored in DBC.idcol. If
ALWAYS and NO CYCLE option is used, then duplicate values
would be avoided.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is teradata?

654


What do you mean by parsing?

641


What is meant by a Clique?

593


Explain the types of join supports by teradata?

596


Syntax for case when statement?

618






What is TPD?

914


What are the joins in teradata and how many types of joins are there in teradata?

585


While creating table my dba has fallback or no fallback in his ddl. What is that?

702


Explain teradata architecture?

643


What are the commands to make a new table, change a table and remove a table in teradata?

621


Can you fastexport a field, which is primary key by putting equality on that key?

721


Which is more efficient group by or distinct to find duplicates?

652


What are the steps to create a data model?

610


How can we check the version of Teradata that we are using currently?

601


How to find duplicates in a table?

624