ReIndexing Database tables with DBCC DBREINDEX and sp_MSforeachtable, then sp_updatestats to refresh statistics. Two scripts, including the one I prefer.
SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database
A long query on INFORMATION_SCHEMA views that shows foreign key relationships for each table: the table, column, referenced table and the constraint name.