S
Shiva Duriseati
Guest
Hi Meryem, To clear the confusion please see the below steps which I performed: 1)Created table with two columns and made both of them as composite key as follow: create table abc(name varchar(20), rno int,primary key(name,rno)); I have inserted few records in the above table. 2)Now I have created view as follows: create view abcview as select * from abc; Now after pulling this object into RB I have assigned name , rno as primary keys and data gets populated without any issue. From my understanding you were creating view by concatenating columns as below: create view abcview as select name,rno,concat(name,rno) from abc; from which you cannot be able to create concat(name,rno) as PRIMARY KEY. Regards, Shiva
Continue reading...
Continue reading...