public void Test158() { var t = Catalog.Schemas["main"].Tables["customer"]; Xtensive.Sql.Model.UniqueConstraint uc = t.CreateUniqueConstraint("newUniqueConstraint", t.TableColumns["Phone"]); SqlAlterTable stmt = SqlDdl.Alter(t, SqlDdl.AddConstraint(uc)); Assert.Throws <NotSupportedException>(() => Console.Write(Compile(stmt))); }
public void Test158() { var t = schema.Tables["customer"]; Xtensive.Sql.Model.UniqueConstraint uc = t.CreateUniqueConstraint("newUniqueConstraint", t.TableColumns["email"]); SqlAlterTable stmt = SqlDdl.Alter(t, SqlDdl.AddConstraint(uc)); Console.Write(Compile(stmt)); }
public void Test159() { var t = Catalog.Schemas["Sakila"].Tables["customer"]; Xtensive.Sql.Model.UniqueConstraint uc = t.CreateUniqueConstraint("newUniqueConstraint", t.TableColumns["email"]); SqlAlterTable stmt = SqlDdl.Alter(t, SqlDdl.DropConstraint(uc)); Console.Write(Compile(stmt)); }
/// <summary> /// Visits unique constraint. /// </summary> /// <param name="constraint">The constraint.</param> /// <returns>Visit result.</returns> protected abstract TResult VisitUniqueConstraint(UniqueConstraint constraint);