what is identity columns in TD?

Answer Posted / tdguy

Identity Columns are system generated numbers for every row
as it is inserted in the table.These columns ensure row
uniqueness in a table.
create table emp
(empno integer
generated always as identity
max value 1000
)
primary index(empno);

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 logical data model?

630


What are the different functions performed in development phase?

564


What is teradata? Also, list out some of the primary characteristics of teradata.

572


What is meant by a Least Cost Plan?

614


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

583






What is the function of parser component in teradata?

613


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

636


What do you mean by teradata intelliflex?

620


What is meant by a Clique?

580


Explain fastload in teradata?

593


how can we analyze the locks ?

1694


List out all forms of LOCKS that are available in Teradata.

543


What do you mean by teradata sql assistant?

582


What is teradata?

637


What are the components provided on node?

564