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