Changing Foreign key names to standard naming convention across the DB

--Vidhyadhar Pandekar
--vidya_pande@yahoo.com
--10th feb,2010
-- Script can be used to standardize the Foreign key names across the database to FK_childTableName_ParentTableName


 select 
 'exec sp_rename '+''''+'['+CCU.TABLE_SCHEMA+'].['+CCU.CONSTRAINT_NAME+']' +
 ''''+','+''''+'FK_'+CCU.TABLE_NAME+'_'+TC1.TABLE_NAME+''''+','+''''+'OBJECT'+''''+CHAR(10)+'GO' 
 from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU
 inner join 
 INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC 
   on CCU.CONSTRAINT_NAME=TC.CONSTRAINT_NAME
 inner join 
 INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC 
   ON TC.CONSTRAINT_NAME=RC.CONSTRAINT_NAME
   inner join INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC1
   ON RC.UNIQUE_CONSTRAINT_NAME=TC1.CONSTRAINT_NAME
 WHERE TC.CONSTRAINT_TYPE='FOREIGN KEY'