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
What are differences between teradata and ansi session modes in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the various indexes in teradata? How to use them?
any one answer me how they can analyzing the project using data ware housing?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is the syntax for case when statement?
Explain the term 'tables' related to relational database management system?
Highlight the limitations of TPUMP Utility.
Highlight a few of the advantages that ETL tools have over Teradata.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain the term 'primary key' related to relational database management system?
How is the teradata different from oracle?
Differentiate database data and data warehouse data?
Highlight the points of differences between the database and user in Teradata.