Advertisement
maranite

T-SQL to conform primary key names

Aug 18th, 2011
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.45 KB | None | 0 0
  1. SET NOCOUNT ON;
  2.  
  3. SELECT
  4.     'EXEC sp_rename ''' + TableName + '.' + OldKeyName + ''', ''' + KeyName + ''';'
  5. FROM (
  6.     SELECT  TableName = CASE WHEN s.name = 'dbo' THEN '' ELSE s.name + '.' END + t.name,
  7.             KeyName = 'PK_' + s.name + '_' + t.name,
  8.             OldKeyName = ix.name
  9.     FROM sys.indexes ix
  10.     JOIN sys.tables t on t.object_id = ix.object_id
  11.     JOIN sys.schemas s on s.schema_id = t.schema_id
  12.     WHERE ix.is_primary_key = 1
  13. ) x
  14. WHERE KeyName <> OldKeyName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement