先查CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE再ALTER TABLE DROP CONSTRAINT

	declare @conname varchar(100), @tabname varchar(255), @sqlcmd varchar(1023);
	set @tabname = 'MyTableName';
	SELECT @conname = CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = @tabname;
	set @sqlcmd = 'ALTER TABLE ' + @tabname + ' DROP CONSTRAINT ' + @conname ;
	exec (@sqlcmd);
	GO

view raw 先查CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE再ALTER TABLE DROP CONSTRAINT hosted with ❤ by GitHub