Script to Rename the indexes, Foreing Key Constraints using SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Script to Rename the indexes, Foreing Key...

Script to Rename the indexes, Foreing Key Constraints using SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

dakshinamurthy-655138

Posted Wednesday, April 29, 2009 6:18 AM

Old Hand

Group: General Forum Members
Last Login: Friday, March 22, 2013 3:39 AM
Points: 327, Visits: 871

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

GilaMonster

Posted Wednesday, April 29, 2009 7:11 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 37,635, Visits: 29,886

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

vijaysingh

Posted Sunday, May 03, 2009 9:50 PM

SSC-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 »

Permissions