Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD
Answer Posted / rahul
hi,
primary keys are not mandatory in the teradata,but when
we are specify the pk in column the optimizer creates the
upi in that column. and more over pk composite have no limit
in teradata. the creation of pk is combination of primary
key and not null see the example
create set/multiset table <table name>
(
orderid integer primary key not null,
---
----- etc
);
this creates upi on the orderid column.
if we doesn't mentioned nupi will be created..
thanks
Rahul
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the newly developed features of Teradata?
how do you manage the production space. what are the proactive methods you can take ?
how many modules are there in telecome domain?how to explain the architecture?
What are types of partition primary index (ppi) in teradata?
How to find duplicates in a table?
What is spool space? Why do you get spool space errors?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How many tables can you join in v2r5?
How can you track login parameters of users in teradata?
What are the different table types that are supported by teradata?
Explain fastload in teradata?
What are the uses of bynets in multi-node systems?
Describe primary index in teradata. And what are the available primary index types?
What are the various indexes in teradata? How to use them?
Why managing the data is important?