Declare @v_constraintname varchar(max)

set @v_constraintname ='ALTER TABLE TableName DROP CONSTRAINT '

set @v_constraintname = @v_constraintname + (select c_obj.name as CONSTRAINT_NAME

from sysobjects c_obj

join syscomments com on c_obj.id = com.id

join sysobjects t_obj on c_obj.parent_obj...