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
How to load specific no.of records using bteq, or fastload,or multiload
what are the uses of fact table and dimension table in banking project?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How would you load a very large file in teradata in general?
What are the various indexes in teradata?
What are the different softwares used with their functions in teradata?
What is stored procedure in teradata?
What is the use of having index on table?
What is the purpose of joins in teradata?
What is the use of teradata system software?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is difference between user and database in teradata?
What is the difference between global temporary tables and volatile temporary tables?
Explain and compare pros and cons of start schemas?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!