alter table <table name> add constraint <constraint name> prim

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

Question Posted / ragunath g

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

Please Help Members By Posting Answers For Below Questions

What is collect statistics?

996

Define views in teradata with syntax.

1075

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2155

Discuss the advantages of using partitioned primary index in a query?

949

What is the syntax for case when statement?

1132

Why do you get spool space errors? How do trouble-shoot them?

1053

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4369

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3618

How to eliminate product joins in a teradata sql query?

1018

What is a clique?

1082

Did you write stored procedures in teradata?

1128

Why teradata is used?

997

What are the 5 phases in a multiload utility?

1031

How is MLOAD Client System restarted after execution?

1143

What is the command in bteq to check for session settings ?

1178