Hi, Thanks for reporting! This is a bug. The database is supposed to drop the objects in the right order; it looks like it doesn't do that currently in this case. I will try to fix it. Test case:
create table a(x int); create view b as select * from a; create table c(y int check (select count(*) from b) = 0); drop all objects delete files; Regards, Thomas On Fri, Nov 15, 2013 at 4:11 PM, Akshay Mehta <[email protected]>wrote: > Hi, > > Is the Statement "Drop All Objects" still checking for dependencies? > > I have a constraint on a Table A, which Checks the value of a column in a > Particular View B. However using "Drop All Objects" reports an error : > "Table A depends on B". > > Any Ideas? > > regards > Akshay > > I am Using: H2 1.3.174 > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
