Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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: Wednesday, September 14, 2016 5:36 AM
Points: 330, Visits: 1,055

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



Group: General Forum Members
Last Login: Yesterday @ 10:06 PM
Points: 45,436, Visits: 43,788
Look up sp_rename in Books Online

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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


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