Wait, I got a better idea. Simply set the referential integrity to false, like:
ALTER TABLE {table_name} SET REFERENTIAL_INTEGRITY false
Then drop the table. It will work :-)
Thought there is a reason why you have a foreign and primary key, no?
So please use caution when doing things like this.
Kind Regards,
Nitai
On Wed, Jan 20, 2010 at 11:13 AM, johnstok <[email protected]> wrote:
> Thanks Nitai,
>
> How do I determine the name of the constraint?
>
> --
> You received this message because you are subscribed to the Google Groups "H2
> Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
>
>
--
See for yourself how easy it is to manage files today. Join the revolution!
Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
http://www.razuna.com/
Razuna - Open Source Digital Asset Management
http://www.razuna.org/
Follow us on Twitter
http://twitter.com/razunahq
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
