![]() |
What are the reason(s) why a PK will be implemented as USI instead of UPI? This question was formulated based on the following statement:
28 Mar 2016
| 9 comments
,
|
![]() |
I have created below table:
03 Sep 2014
| 1 comment
,
|
![]() |
Hi All,
16 Aug 2013
| 4 comments
,
|
![]() |
All
16 Jul 2013
| 1 comment
,
|
![]() |
How is primary key concept implemented in teradata?(like primary index is implemented using hash algorithm).
26 Dec 2011
| 1 comment
,
|
![]() |
Hi,
We can define primary key on a table in teradata.It can be a different column from the primary index in teradata.
How does primary key concept implemented in teradata. like primary index is implemented using hashing algorithm.
09 Dec 2011
,
|
![]() |
I have been fighting with this for weeks now. Basically I have .NET application that is using a teradata backend. I cannot for the life of me figure out why I keep getting this error, and it's random. The application itself does not specify any auto increment. I'm leaving that up to Teradata using the following create statement. Again - this has been completely random. It can be from updating a record or creating a new record. CREATE TABLE BCPM_DDBO.LTC_FBS
03 Aug 2011
| 1 comment
,
|
![]() |
I have noticed that while creating a table, I can create Primary Keys using the following syntax : CONSTRAINT name PRIMARY KEY (column1, column2....) However if I pull up the SQL for table creation after the initial create, this becomes UNIQUE PRIMARY INDEX name (column1, column2...)
14 Apr 2011
| 2 comments
,
|
![]() |
Hi, I need to find a few key pieces of metadata about a table's columns. I am using JDBC so the information can be obtained using SQL or jdbc methods like getPrimaryKey etc...
29 Mar 2011
| 3 comments
,
|
![]() |
Can any one tell me what is the difference between key and index? what is the difference between primary key and unique primary key? Thanks
17 Feb 2011
| 4 comments
,
|