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%'
No comments:
Post a Comment