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
 General SQL Server Forums
 New to SQL Server Programming
 Question about renaming a column name

Author  Topic 

skiabox
Posting Yak Master

169 Posts

Posted - 2008-12-09 : 04:26:43
Is it safe to rename column names?
What if these columns are parts of various constraints?
Thank you.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-12-09 : 06:36:04
it is not suggested to rename the column in production environment.

Arnav
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-09 : 09:43:54
just remember that all depending on table like procedures,trigger,... might break if they happen to use the column. so probably you need to look for dependency using sp_depends before doing it.
Go to Top of Page
   

- Advertisement -