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


Please Help Members By Posting Answers For Below Questions

What are the newly developed features of Teradata?

551


how do you manage the production space. what are the proactive methods you can take ?

1456


how many modules are there in telecome domain?how to explain the architecture?

1533


What are types of partition primary index (ppi) in teradata?

566


How to find duplicates in a table?

585






What is spool space? Why do you get spool space errors?

486


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1647


How many tables can you join in v2r5?

596


How can you track login parameters of users in teradata?

604


What are the different table types that are supported by teradata?

521


Explain fastload in teradata?

571


What are the uses of bynets in multi-node systems?

563


Describe primary index in teradata. And what are the available primary index types?

520


What are the various indexes in teradata? How to use them?

533


Why managing the data is important?

562