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

if collect stats but it show low confidence why?

1200

What is collect statistics?

598

Name the five phases that come under MultiLoad Utility.

591

What are the joins in teradata?

582

Highlight the need for Performance Tuning.

599

What do you mean by teradata intellicloud?

605

Explain the new features of teradata?

578

Difference between star and snowflake schemas?

611

Explain vproc in teradata?

572

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

582

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1749

List the logical and conditional operators that are used with teradata along with their meanings?

562

What are the primary characteristics of the Teradata.

599

List out some of the primary characteristics of teradata.

572

Define views in teradata with syntax.

651