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 differences between teradata and ansi session modes in teradata?

1175

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

987

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

1178

What are the various indexes in teradata? How to use them?

1018

any one answer me how they can analyzing the project using data ware housing?

2480

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

2204

What is the syntax for case when statement?

1144

Explain the term 'tables' related to relational database management system?

1050

Highlight the limitations of TPUMP Utility.

1111

Highlight a few of the advantages that ETL tools have over Teradata.

1090

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

1098

Explain the term 'primary key' related to relational database management system?

1036

How is the teradata different from oracle?

1116

Differentiate database data and data warehouse data?

1116

Highlight the points of differences between the database and user in Teradata.

1109