Creating table with defined PK but not defining PI

Database

Creating table with defined PK but not defining PI

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?

If remove the PK from table create staement it is automatically selecting col1 as PI. If I define both PI and PK on col1 and col2 it is throwing error.

1 REPLY
N/A

Re: Creating table with defined PK but not defining PI

Hi Moutusi,

A few years ago the result of a SHOW TABLE was changed to return the logical constraints instead of the internally created indexes.

So you still get a UPI on (col1,col2), but you have to figure it out yourself - I never liked the new output :(

When you query dbc.IndicesV you'll see a IndexNumber 1 for it, indicating it's the PI.