Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD

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

Explain amp in teradata?

579


Describe the set operators in teradata.

586


what is sysdba and sysdbc ? which has high priority ?

3376


Difference between inner join and outer join?

589


What do you mean by teradata intellicloud?

603






What is meant by a Clique?

591


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

607


What is the multi-insert?

618


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1902


What are types of partition primary index (ppi) in teradata?

592


what are the uses of fact table and dimension table in banking project?

4108


What are the steps involved in the process flow of the sql statement through channel attached system?

662


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

580


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

660


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

552