what is identity columns in teradata

Answer Posted / yuvaevergreen

Identity column is a system generated value. Used for row
uniqueness. If rows need to be unique, then ALWAYS option
should be used with NO CYCLE option. Separate DBC table
takes care of identity columns DBC.idcol.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for case when statement?

816


What is the multi-insert?

803


What do you mean by tpt in teradata?

785


Comment whether bottleneck is an error or not.

840


In BTEQ, how are the session-mode parameters being set?

908


What are the main components of teradata system?

822


What is meant by Teradata Gateway?

825


how can we analyze the locks ?

1879


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

901


Highlight a few of the important components of Teradata?

792


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

870


How does hashing happens in teradata?

841


What is the basic syntax for teradata select statement?

773


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

838


Explain teradata utilities?

759