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); }