public void DropReferencedTable()
        {
            var tableName = ObjectName.Parse("APP.test_table1");
            var statement = new DropTableStatement(tableName);

            Assert.Throws<ConstraintViolationException>(() => statement.Execute(Query));

            var exists = Query.TableExists(tableName);
            Assert.IsTrue(exists);
        }
        public void DropNonReferencedTable()
        {
            var tableName = ObjectName.Parse("APP.test_table2");
            var statement = new DropTableStatement(tableName);

            statement.Execute(Query);

            var exists = Query.TableExists(tableName);
            Assert.IsFalse(exists);
        }
        public void DropIfExists_TableNotExists()
        {
            var tableName = ObjectName.Parse("APP.test_table3");
            var statement = new DropTableStatement(tableName, true);

            statement.Execute(Query);

            var exists = Query.TableExists(tableName);
            Assert.IsFalse(exists);
        }
Beispiel #4
0
        public void DropReferencedTable()
        {
            var tableName = ObjectName.Parse("APP.test_table1");
            var statement = new DropTableStatement(tableName);

            Assert.Throws <ConstraintViolationException>(() => statement.Execute(Query));

            var exists = Query.TableExists(tableName);

            Assert.IsTrue(exists);
        }
Beispiel #5
0
        public void DropIfExists_TableNotExists()
        {
            var tableName = ObjectName.Parse("APP.test_table3");
            var statement = new DropTableStatement(tableName, true);

            statement.Execute(Query);

            var exists = Query.TableExists(tableName);

            Assert.IsFalse(exists);
        }
Beispiel #6
0
        public void DropNonReferencedTable()
        {
            var tableName = ObjectName.Parse("APP.test_table2");
            var statement = new DropTableStatement(tableName);

            statement.Execute(Query);

            var exists = Query.TableExists(tableName);

            Assert.IsFalse(exists);
        }