I have tables A,B,C in which B table acts as Bridge table. My question is I want to hide all the columns in the Bridge table. But I don't want to hide the corresponding key columns in the A and C tables.
Table A -- Key1, Col1, Col2
Table B - Key 1, Key2
Table C- key2,Col13, Col4
Using SETHidePrefix = '_'; it may hide the column in bridge but join is not happening between the tables. Please advice.