public void DropReferencedColumn() { var tableName = ObjectName.Parse("APP.test_table2"); var expected = Is.InstanceOf <ConstraintViolationException>() .And.TypeOf <DropColumnViolationException>(); Assert.Throws(expected, () => AdminQuery.DropColumn(tableName, "person_id")); }
public void DropColumn() { var tableName = ObjectName.Parse("APP.test_table"); AdminQuery.DropColumn(tableName, "active"); var testTable = AdminQuery.Access().GetTable(ObjectName.Parse("APP.test_table")); Assert.IsNotNull(testTable); Assert.AreEqual(-1, testTable.TableInfo.IndexOfColumn("active")); }