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:
"Primary keys are implemented as unique secondary indexes for non-temporal tables..."

I have created below table:
create table T1
(
col1 varchar (20)
,col2 int
,col3 varchar (10)
, primary key (col1, col2));
After creating this table while executing show select * from T1 I found no PI has been choosen by Teradata.
Will teradata treat this table as NOPI?

Hi All,
    While creating a table if i specify both the Primary Index and Primary Key on the same column the table cretion fails.

All
I am new to Teradata and debugging a issue related to insert. I have two tables in teradata. Find below the definitions
CREATE SET TABLE TablePrimary ,NO FALLBACK ,
   NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (

How is primary key concept implemented in teradata?(like primary index is implemented using hash algorithm).
 

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.

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
(FBS_ID INTEGER not null GENERATED BY DEFAULT AS IDENTITY
(START WITH 1
INCREMENT BY 1),
DBS_NM varchar(50),

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...)

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...

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
Ashok Reddy Daggula