Delete a column XYZ from a table ABC which is a part of merge replication

• chandrakant_gaurav

  Right there with Babe

  Points: 799

  More actions

  December 12, 2013 at 5:44 am

  #280106

  Guys,

  I have a task to delete a column XYZ from a table ABC. It is not a having any constraints on it, Its datatype is UNIQUEIDENTIFIER, I have done some research and come up with below script:

  --**********************************************

  declare @tbl sysname

  declare @col sysname

  set @tbl='ABC'

  set @col='XYZ'

  exec sp_repldropcolumn @tbl, @col

  --**********************************************

  I am a database developer and not a DBA. I plan to take a backup before running is but I cannot test this beforehand. Need to run directly on prod. Kindly assist with what can go wrong with this, or if some other approach is more suitable? Precautions, etc.

  Thanks

  Gaurav