sp_rename

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  February 17, 2013 at 5:57 am

  #394203

  Hi All,

  I need to use sp_rename - http://msdn.microsoft.com/en-us/library/ms188351.aspx

  I need to use it for tables in the following way:

  For an existing "table_name" table i create "table_name_new" table. I copy all the data from "table_name" to "table_name_new". Then i drop "table_name" and rename "table_name_new" to "table_name". Finally i create the FKs and indexes with same definitions as they were in "table_name".

  I know it could be problematic using sp_rename for some other objects like SPs, FNs ...

  Has anyone experienced any problems with renaming a table in this way. Please share.

  Can anyone confirm as save the usage of sp_rename, and/or suggest something additionally.

  Thanks

  IgorMi

  Igor Micev,My blog: www.igormicev.com

• jeetsingh.cs

  SSCommitted

  Points: 1761

  More actions

  February 18, 2013 at 3:13 am

  #1588767

  you should first check the dependencies for the particular object

  by sp_depends

  or by sys.dm_sql_referencing_entities ('OBJECT', 'OBJECT');

  then you can modify your object in a more appropriate way