I have 3 tables currently in sql server 2005 which has references
TABLE A --- MAIN TABLE
TABLE B Child Table Student_ID Column as FK
TABLE c Child Table Student_ID Column as FK
Now lets say I want to delete a Row of Student_ID in Table A.... How can I check if that Student_ID is being referenced Or Used in Table B or TABLE C...........is there a easy way to check it .