ALTER TABLE myLib.ResultTb ADD PRIMARY KEY (ColA, ColB);
Disclaimer: Any views or opinions presented are solely those of the author
and do not necessarily represent those of the company.
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of K
Sent: Tuesday, August 2, 2022 9:10 AM
Subject: SQL Create Table AS with primary key
I have an SQL statement like this, I want to add a key to the table
CREATE TABLE myLib.ResultTbl AS
Select t1.ColA, t1.ColB, t1.ColC, t2.ColA, t1.ColD
from myLib.Table1 t1
join myLib.Table2 t2
on t1.ColA = t2.ColA and t1.ColB = t2.ColB
where t1.ColA = 208
and t1.ColR = 'Y'
and t1.ColB in
from myLib.Table1 t1b
where t1b.ColA = 208
and t1b.ColR != 'Y'
and t1b.ColM = 2023
I want to add a key to the result table myLib.ResultTbl.
I have tried adding 'primary key (t1.ColA, t1.ColB)' but not working.
Is my only option to follow this create with a create index?
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.