Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in TD?
- 2 Answers
- 5669 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 ? | 2 Yes | 0 No |
Explain the types of join supports by teradata?
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
Write a program to show the parser component used in teradata?
Steps to create a data model?
What is called partitioned primary index (ppi)?
How does indexing improve query performance?
Highlight a few of the important components of Teradata?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Which is more efficient group by or distinct to find duplicates?
What are the string manipulation operators and functions associated with teradata?
What is the difference between union and union all in teradata?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
Teradata 
