SQLTeam.com | Weblogs | Forums

Effect of rename column_name

sql2008

#1

when i rename column using this query :-1:
sp_rename 'test.cust_namme','cust_name','column'
go
then got a msg
Caution: Changing any part of an object name could break scripts and stored procedures.
what is the acutal effect of this msg.


#2

None, its only letting you know in case you have other objects relying on the previous column name before it was changed. If you do have other objects relating to the old column name they will need to be modified to comply with the new name.


#3

It means If you have used the column in any stored procedures, functions or views that will throw an error


#4

thanks for support