Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD
Answer Posted / 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 |
Post New Answer View All Answers
What are the uses of client software involved in teradata?
Highlight the advantages of PPI(Partition Primary Index).
Explain the meaning of Amp?
Highlight the need for Performance Tuning.
Highlight the limitations of TPUMP Utility.
What does Amp contain and what are all the operations that it performs?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
what is object level locking ? where do appear this type of locking ?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is meant by a Clique?
What are default access rights in teradata? What explicit right can be given to a user?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Highlight the differences between Primary Key and Primary Index.
Highlight the points of differences between the database and user in Teradata.
Highlight a few of the important components of Teradata?