YOU SAID:
string uniqueConstraintNameVariableName = "@" + tableName + "_" + columnName + "_ConstraintName"; return @"DECLARE " + uniqueConstraintNameVariableName + @" nvarchar(200) SELECT " + uniqueConstraintNameVariableName + @" = Name FROM SYS.DEFAULT_CONSTRAINTS WHERE PARENT_OBJECT_ID = OBJECT_ID('" + tableName + @"') AND PARENT_COLUMN_ID = (SELECT column_id FROM sys.columns WHERE NAME = N'" + columnName + @"' AND object_id = OBJECT_ID(N'" + tableName + @"')) IF " + uniqueConstraintNameVariableName + @" IS NOT NULL EXEC('ALTER TABLE " + tableName + @" DROP CONSTRAINT ' + " + uniqueConstraintNameVariableName + ")";
INTO JAPANESE
uniqueConstraintNameVariableName の文字列 ="@"tableName +「_」+ columnName +"_ConstraintName"; 返す @"DECLARE"+ uniqueConstraintNameVariableName + @"nvarchar(200) 選択"+ uniqueConstraintNameVariableName + @」= sys という名前から。DEFAULT_CONSTRAINTS、PARENT_OBJECT_ID = オブジェクト
BACK INTO ENGLISH
string uniqueConstraintNameVariableName = @ tableName + "_" + columnName + "_ConstraintName"; Return @ + uniqueConstraintNameVariableName 'DECLARE' @ 'nvarchar (200) select' + uniqueConstraintNameVariableName + @ "name = sys. DEFAULT_CONSTRAINTS and PARENT_OBJECT_ID = object
INTO JAPANESE
uniqueConstraintNameVariableName の文字列 ="_ConstraintName"; columnName +「_」tableName @@ リターン + uniqueConstraintNameVariableName 'DECLARE' @ 'nvarchar (200) 選択' + uniqueConstraintNameVariableName + @"名前 = sys。DEFAULT_CONSTRAINTS と PARENT_OBJECT_ID オブジェクトを =
BACK INTO ENGLISH
string uniqueConstraintNameVariableName = "_ConstraintName"; columnName + "_" tableName @ @ return + uniqueConstraintNameVariableName 'DECLARE' @ uniqueConstraintNameVariableName 'nvarchar (200) select' + @ "name = sys. PARENT_OBJECT_ID object with DEFAULT_CONSTRAINTS.
INTO JAPANESE
uniqueConstraintNameVariableName の文字列 ="_ConstraintName";columnName +「_」tableName @ @ リターン + uniqueConstraintNameVariableName 'DECLARE' uniqueConstraintNameVariableName nvarchar (200) 選択 @ + @"名前 = sys。DEFAULT_CONSTRAINTS を持つ PARENT_OBJECT_ID オブジェクト。
BACK INTO ENGLISH
string uniqueConstraintNameVariableName = "_ConstraintName"; tableName columnName + "_" @ @ return + uniqueConstraintNameVariableName 'DECLARE' uniqueConstraintNameVariableName nvarchar (200) select @ + @ "name = sys. PARENT_OBJECT_ID object with DEFAULT_CONSTRAINTS.
INTO JAPANESE
uniqueConstraintNameVariableName の文字列 ="_ConstraintName";tableName columnName +「_」@ @ リターン + uniqueConstraintNameVariableName 'DECLARE' uniqueConstraintNameVariableName nvarchar (200) 選択 @ + @"名前 = sys。DEFAULT_CONSTRAINTS を持つ PARENT_OBJECT_ID オブジェクト。
BACK INTO ENGLISH
string uniqueConstraintNameVariableName = "_ConstraintName"; tableName columnName + "_" @ @ return + uniqueConstraintNameVariableName 'DECLARE' uniqueConstraintNameVariableName nvarchar (200) select @ + @ "name = sys. PARENT_OBJECT_ID object with DEFAULT_CONSTRAINTS.
You've done this before, haven't you.