public static string DropConstraint(SysConstraint constraint)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{constraint.qualified_name}') IS NOT NULL)",
"BEGIN",
$"\tALTER TABLE {constraint.qualified_table_name}",
$"\tDROP CONSTRAINT [{constraint.name}]",
"END\n"
}));
}
public static string AddCheckConstraint(SysConstraint constraint)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{constraint.qualified_name}') IS NULL)",
"BEGIN",
$"\tALTER TABLE {constraint.qualified_table_name} WITH {constraint.check_status}",
$"\tADD CONSTRAINT [{constraint.name}] CHECK {constraint.definition}",
"END\n"
}));
}
public static string AddUniqueConstraint(SysConstraint constraint)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{constraint.qualified_name}') IS NULL)",
"BEGIN",
$"\tALTER TABLE {constraint.qualified_table_name}",
$"\tADD CONSTRAINT [{constraint.name}] UNIQUE ({constraint.columns})",
"END\n"
}));
}
public static string AddDefaultConstraint(SysConstraint constraint)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{constraint.qualified_name}') IS NULL)",
"BEGIN",
$"\tALTER TABLE {constraint.qualified_table_name}",
$"\tADD CONSTRAINT [{constraint.name}] DEFAULT {constraint.definition} FOR [{constraint.columns}]",
"END\n"
}));
}
public static string AddPrimaryKey(SysConstraint key)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{key.qualified_name}') IS NULL)",
"BEGIN",
$"\tALTER TABLE {key.qualified_table_name}",
$"\tADD CONSTRAINT [{key.name}] PRIMARY KEY ({key.columns})",
"END\n"
}));
}
private bool DependsOn(SysConstraint constraint, SysColumn column)
{
if (constraint == null)
{
return(false);
}
else if (constraint.columns.Contains(",") && constraint.columns.Split(",").Contains(column.name))
{
return(true);
}
else if (constraint.columns == column.name)
{
return(true);
}
return(false);
}
