Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD




Answers were Sorted based on User's Feedback



Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD..

Answer / 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

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD..

Answer / tdguy

PK is a logical concept and not mandatory in TD. But PI is
mandatory as the distribution of data is completely
dependent on PI. Choice of PI is very important and can
contain upto 16 columns.

Is This Answer Correct ?    3 Yes 0 No

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD..

Answer / sasty venkatesh

In teradata primary key concept can be satisfied by creating unique primary index and unique secondary index.

Is This Answer Correct ?    2 Yes 2 No




Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD..

Answer / ragunath g

alter table <table name> add constraint <constraint name>
primary key<column name>

This is the Syntax for adding PK

Is This Answer Correct ?    0 Yes 0 No

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD..

Answer / santhosh kumar

In Teradata don't care about PK.. Table in Teradata need Primary Index not primary key.. so in teradata no need to bother about PK.

Is This Answer Correct ?    1 Yes 2 No

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD..

Answer / santhosh

In teradata for storing and retrieving purpose, PE will use
primary index only.. but we are using PK in teradata for creating joins.. soo in Teradata we are using PK and FK..

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Teradata Interview Questions

What is meant by a node?

0 Answers  


Difference between multiload and tpump?

0 Answers  


What's the difference between timestamp (0) and timestamp (6)?

0 Answers  


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,


How to find duplicates in a table?

0 Answers  






How does indexing improve query performance?

4 Answers   Satyam,


Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,


What does Amp contain and what are all the operations that it performs?

0 Answers  


I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,


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

0 Answers  


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers  


Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

4 Answers   Teradata,






Categories