rename a column name in a table ?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  March 6, 2006 at 4:32 am

  #171352

  Is it possible to use a stored procedure to rename a column name in a table without losing the data held within it?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  March 6, 2006 at 5:30 am

  #624844

  I've found this by searching this forum,

  exec sp_rename 'dbo.TableName.newcol','OldCol','COLUMN'

  what I'd like to do is make a Stored procedure that I can pass in TableName, oldcolumn, newColumn. So it needs to be done dynamically

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  March 6, 2006 at 7:28 am

  #624869

  you can create a procedure that uses sp_rename...something like this:

  create procedure sp_ChangeColumnName
  @table_name varchar(50),
  @old_name varchar(50),
  @new_name varchar(50)
  as
  
  declare @sql varchar(150)
  
  set @sql = 'sp_rename "' + @table_name + '.' + @old_name + '", "' + @new_name + '", "' + 'column"'
  exec(@sql)
  
  Then execute this by passing the parameters...
  
  
  exec sp_ChangeColumnName 'table_name', 'old_name', 'new_name'
  

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• devaraya

  Default port

  Points: 1455

  More actions

  March 7, 2006 at 2:31 am

  #625124

  Go to Enterprise Manager,select database, select the table name and select the column name right click select design table. You can change what ever you want. Ok....

  Ramaa

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  March 7, 2006 at 2:52 am

  #625128

  many thanks Rama, that's helped a great deal