SELECT 'ALTER TABLE ' +  s2.name + ' DROP CONSTRAINT ' + s1.name 
FROM sysobjects s1 
INNER JOIN
	sysconstraints sc ON s1.id=sc.constrid 
INNER JOIN 
	sysobjects s2 ON sc.tableid = s2.id 
WHERE s1.type = 'R'