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 upsert statement in teradata?

1051

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

2099

What is bteq script in teradata?

1076

Why are oltp database designs not generally a good idea for a data warehouse?

989

Explain PDE.

1012

what is object level locking ? where do appear this type of locking ?

3446

What are the different softwares used with their functions in teradata?

966

Explain some differences between mpp and smp?

1035

Explain the teradata primary index mechanics in detail with a diagram.

910

Highlight all the modes that are present under Confidence Level.

915

What is a node in teradata?

935

What is multi insert?

984

What is meant by a Highest Cost Plan?

988

why use references rather than pointers in the public api, particularly for arguments which are modified?

937

What is the difference between fastload and multiload?

1289