SQLUSA
 

Microsoft SQL Server 2000

Best Practices

 

How to find all the foreign keys pointing to a table?

 

Use the system stored procedure:

exec sp_fkeys Orders

You get the listings of all the tables which are using the primary key of the Orders table.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page