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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you determine the number of sessions?

606


What interface is used to connect to windows based applications?

574


In Teradata, what is the significance of UPSERT command?

580


What is the purpose of upsert command?

584


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

587






Can you fastexport a field, which is primary key by putting equality on that key?

701


What are the string manipulation operators and functions associated with teradata?

623


What is meant by a Virtual Disk?

568


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

670


Explain BYNET.

596


Which is more efficient group by or distinct to find duplicates?

630


How is MLOAD Teradata Server restarted after execution?

639


Describe the set operators in teradata.

572


Explain PDE.

596


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

576