level 11
IF EXISTS(select 1 from information_schema.key_column_usage where TABLE_NAME=*tbMvouttocustomer_Detail*)
BEGIN
DECLARE @PK_primary_temp VARCHAR(255), @SqlTemp VARCHAR(2048)
SET @PK_primary_temp=(SELECT TOP 1 CONSTRAINT_NAME from information_schema.key_column_usage where TABLE_NAME=*tbMvouttocustomer_Detail*)
SET @SqlTemp =* ALTER TABLE tbMvouttocustomer_Detail DROP CONSTRAINT *+@PK_primary_temp
EXEC(@SqlTemp)
END
GO
--为从表建立主键约束
if not exists(select * from sysindexes where id=object_id(*tbMvouttocustomer_Detail*) and name=*PK_tbmvouttocustomerDetail_PrimaryKey*)
ALTER TABLE tbMvouttocustomer_Detail ADD CONSTRAINT PK_tbmvouttocustomerDetail_PrimaryKey PRIMARY KEY CLUSTERED([sid])
GO
2014年11月14日 03点11分