public static string DropForeignKey(SysForeignKey key)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{key.qualified_name}') IS NOT NULL)",
"BEGIN",
$"\tALTER TABLE {key.qualified_parent_table}",
$"\tDROP CONSTRAINT [{key.constraint_name}]",
"END\n"
}));
}
public static string AddForeignKey(SysForeignKey key)
{
return(string.Join("\n", new string[]
{
$"IF (OBJECT_ID('{key.qualified_name}') IS NULL)",
"BEGIN",
$"\tALTER TABLE {key.qualified_parent_table} WITH {key.check_status} ADD CONSTRAINT [{key.constraint_name}] FOREIGN KEY([{key.parent_column}])",
$"\tREFERENCES {key.qualified_referenced_table} ([{key.referenced_column}])",
"END\n"
}));
}
