 |
 |
Archives of the TeradataForum
Message Posted: Wed, 24 Sep 2003 @ 20:43:34 GMT
| Subj: | | Re: Changing PK values |
| |
| From: | | Dieter Noeth |
Anomy Anom wrote:
| | Teradata manual (Introduction to TD) says that the primary key values can not be changed. | |
| | However I am able to change this value. | |
| | Is that an error in the manual or any other explanations available to that? | |
According to the Relational Model a Primary Key must be unique, cannot be changed and may not be NULL, so the manual is right.
You're confused by Teradata's Primary Index, which may be changed, may be non-unique and may include NULL.
There are lots of differences between real world DBMSes and the Relational Model ;-) E.g. according to Relational Model every table needs
a PK, but not according to Standard SQL.
Dieter
| |
