Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: 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.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    All that means is that you will have to update references to the column name in any code that has already been created.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts