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
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: Thursday, October 1, 2015 1:14 AM
Points: 330, Visits: 995

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: Today @ 9:14 AM
Points: 42,998, Visits: 39,974
Look up sp_rename in Books Online

Gail Shaw
Microsoft Certified Master: SQL Server, 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


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