Hi,
Is there a way to find out that a record has been used as foreign key in other tables (without using SELECT syntax)?
example:
- TableA
AId AName
------ ---------
001 Anonymous1
002 Anonymous2
- TableB
BId BName AId
------ --------- ------
111 AnyName 001
Column AId in TableB is a foreign key to Table A.
I want to find out that AId 001 has been used in TableB,
but without using SELECT statement.
any help will be appreciated.
Is there a way to find out that a record has been used as foreign key in other tables (without using SELECT syntax)?
example:
- TableA
AId AName
------ ---------
001 Anonymous1
002 Anonymous2
- TableB
BId BName AId
------ --------- ------
111 AnyName 001
Column AId in TableB is a foreign key to Table A.
I want to find out that AId 001 has been used in TableB,
but without using SELECT statement.
any help will be appreciated.