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 are the primary characteristics of the Teradata.

799

List out teradata data types?

753

what are the day to day activities of teradata DBA ?

5568

What is the difference between union and union all in teradata?

825

How is MLOAD Teradata Server restarted after execution?

899

Explain vproc in teradata?

759

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1914

What do you mean by tpt in teradata?

771

Explain how spool space is used.

836

What is the use of having index on table?

743

In Teradata, what is the significance of UPSERT command?

798

What is inner join and outer join?

814

What are the different table types that are supported by teradata?

749

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

722

Define views in teradata with general syntax.

773