Its just a simplification. In reality this view selects many columns.

-Onkar

Thanks for the response Ian/David. I understand "delete" operation will not lead to any data inconsistency. As I am new to SQL Server, I am not very sure how to...

Thanks for the response Adi. I have found a work around for my problem but the solution is not full proof I mean it might create some data issue.

Work...