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
Explain amp in teradata?
how many modules are there in telecome domain?how to explain the architecture?
If RDBMS is halted what will you do ?
What is oltp?
What are the various indexes in teradata? Why are they preferred?
What are teradata utilities?
What is database exceptions in teradata?
What are the scenarios in which full table scans occurs?
Why managing the data is important?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is teradata? What are some primary characteristics of teradata?
Highlight all the modes that are present under Confidence Level.
How do you do backup and recovery in teradata?
Highlight the points of differences between the database and user in Teradata.
What are the main components of teradata system?