Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to Rename the indexes, Foreing Key Constraints using SQL Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, April 29, 2009 6:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:22 AM
Points: 330, Visits: 962
Hi,

I would like to know how to write the Script to Rename the indexes or Foreign Key constraints using SQL Server 2005,

i have certain indexes in my table, where in i have to change the names for the indexes which is given the name wrongly.

With Regards
Dakshina Murthy
Post #706713
Posted Wednesday, April 29, 2009 7:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 42,460, Visits: 35,520
Look up sp_rename in Books Online


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #706775
Posted Sunday, May 3, 2009 9:50 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 29, 2010 5:42 AM
Points: 412, Visits: 149
Thanks i will try that


with regards
Dakshina murthy
Post #709163
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse