Interested to Buy Any Domain ? << Click Here >> for more details...
Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD
- 6 Answers
- 11971 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
If a Node is busy what are the steps you can take to avoid ?
What are the available join types in teradata?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
What is called partitioned primary index (ppi)?
Which Teradata concept allows more than one model generation?
What is a node in teradata?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
write lock is compatiable with which type of lock?
What is oltp?
What are the multiload utility limitations?
What is the difference between teradata and basic rdbms?
How many sessions of MAX is PE capable of handling at a particular time?
Teradata 
