Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 rename indexes

Author  Topic 

sacok
Starting Member

9 Posts

Posted - 2001-01-16 : 12:27:07
i need to rename all the indexes on all tables, what is the best way in doing this ,do i do an update the table names or the sysobjects where type is 'f' as there are different naming that has been used so i need to standardised it name by changing all to PK_<column name>.

thanks

sacok

   

- Advertisement -