Tuesday, March 27, 2012

Changing column name

Hi all,

I have a table that has integrity constraints in place and it is populated with the data. I need to rename one of the columns in the table. I am hesitant to use sp_rename procedure because when I used it before I get a warning message that says "changing any part of an object name could break scriptd and stored procedure." how big of a problem is it? Is there any other way to do it without hearting anything? Thanks.All that means is that you will have to update references to the column name in any code that has already been created.sql

No comments:

Post a Comment