SQL Server offers several tools to validate foreign keys, such as built-in features in SSMS like the Database Diagram tool, Object Explorer, and DBCC commands.

SQL Server Management Studio Alternatives that are Free. I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 ...