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
Why managing the data is important?
What is a node in teradata?
What are different table types used in teradata?
What interface is used to connect to windows based applications?
What are the newly developed features of Teradata?
How to run a query in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How do you do backup and recovery in teradata?
Highlight the differences between Primary Key and Primary Index.
What's the difference between timestamp (0) and timestamp (6)?
Highlight all the modes that are present under Confidence Level.
Highlight a few of the advantages that ETL tools have over Teradata.
What are the multiload utility limitations?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain and compare pros and cons of snow flake schemas?
