Experts and those more knowledgeable than I,
I have a trigger on insert of table A, insert the value of A.message to table B.
My full text index is on B.message.
After the B.message is Indexed and added to the generated table by Using Full Text Index; TA_B.. Can I delete B where B.ID = TA_B.ID?
I did a test..
The data is still there, after I deleted the value from B
I forced a Delta Merge on all tables involved..
Can anybody give me a little more re assurance that deleting from B will not delete my data in TA_B?
THank you for your time and diligence.