/// <summary>
/// Translates this constraint into a SQL script
/// </summary>
/// <returns></returns>
public string Script()
{
return(Type != ConstraintType.Index
?
$"CONSTRAINT [{Name}] {ConvertToString(Type)} {ClusteredText} ([{string.Join("], [", Columns.ToArray())}])"
:
$"CREATE {UniqueText} {ClusteredText} INDEX [{Name}] ON [{Table.Owner}].[{Table.Name}] ([{string.Join("], [", Columns.ToArray())}])");
}
