troubleshootingsql.com
Script to remove a constraint and drop columns
Recently there was a need to get rid of a replication column after replication was disabled on a SQL Server 2000 database. The customer wanted to get rid of a column for all the tables which replic…