Find Tables That Have Foreign Key
28 July 2009
One Comment
It’s pretty simple. Just run the following SQL statement on the database you are working on:
SELECT * FROM Information_Schema.TABLE_CONSTRAINTS
WHERE TABLE_NAME = ‘mytable’ AND CONSTRAINT_TYPE = ‘foreign key’
As you can see, this query can be used also for looking other CONSTRAINTS.
Medicamentspot.com International Legal RX Medications. Special Internet Prices (up to 40% off average US price). NO PRIOR PRESCRIPTION REQUIRED!…
Combivir@buy.online” rel=”nofollow”>.…
Leave your response!
You must be logged in to post a comment.