TSQL Script - To change Primary key names to standard naming convention across the DB

SELECT 'exec sp_rename '+''''+'['+S.name+'].['+b.name+']'+''''+','+''''+'PK_'+a.name+''''+','+''''+'OBJECT'+''''+CHAR(10)+'GO'
FROM sys.objects a
INNER JOIN  sys.indexes b ON a.object_id=b.object_id
INNER JOIN sys.schemas S ON a.schema_id=S.schema_id
WHERE a.object_id =b.object_id AND (b.is_primary_key=1 )
AND a.type='U' AND a.name not like 'sys%'

Reference : Pinal Dave  (http://blog.SQLAuthority.com)

See Also:

• T-SQL Scripts