Microsoft SQL Server 2000
Best Practices
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.