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

6 Answers
12181 Views
Wipro, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are teradata utilities?

1155

Why is the case expression used in teradata?

1136

what are the day to day activities of teradata DBA ?

5860

What do you mean by fastexport in teradata?

1047

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

1116

How do you do backup and recovery in teradata?

1078

What is the difference between teradata and basic rdbms?

1074

What is teradata?

1238

List out teradata data types?

1064

How do you define Teradata?

1087

What are tpump utility limitations?

1176

Explain teradata utilities. What is multiload, fast load, tpump?

1049

Explain the advantages of partitioned primary index in a query?

1074

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1081

Write a program to show the parser component used in teradata?

1027