what is identity columns in TD?
- 2 Answers
- 4875 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 |
What is FILLER command in Teradata?
What is the default join strategy in Teradata???
Can we collect statistics on multiple columns?
What are the components provided on node?
What are the different table types supported by teradata?
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
What are default access rights in teradata? What explicit right can be given to a user?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
what is meant by Hot amp?
how do you manage the production space. what are the proactive methods you can take ?
Differentiate database data and data warehouse data?
Teradata 
