[RESOLVED] Sql Foreign keys help!
Hi.
I have some tables and i want to view their Relationships.
Let's say i have a table named "Help"
i use the Stored procedure "sp_fkeys" to get the Fkey-keys of the tables that refear table "Help". What i cannot do is the opposite. Meaning that i want to see the tables that "Help" is refearing. And not sp_pkeys does not work :)
Any ideas?
Re: Sql Foreign keys help!
sp_fkeys @pktable_name='help'
returns all tables that refer to 'help'
sp_fkeys @fktable_name='help'
returns all tables that 'help' refers to.
Re: Sql Foreign keys help!