db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fporto <fabio.machadopo...@gmail.com>
Subject How to retrieve the constraints associated to a table
Date Sun, 25 May 2008 11:01:19 GMT

Hi,
 I'm receiving the following message when trying to drop a table:

ERROR X0Y25: Operation 'DROP CONSTRAINT' cannot be performed on object
'SQL080516103912600' because CONSTRAINT 'SQL080525110646121' is dependent on
that object.

I would like to obtain the list of constraints associated to each of my
tables.
I've tried to use the Describe SQL command but it doesn't print constraint
info.

I've also tried to query system tables:sysconstraints, sysdepends but
couldn't find the objects referred to in the msgs.

Can someone there help me on this?

cheers,
Fabio.
  
-- 
View this message in context: http://www.nabble.com/How-to-retrieve-the-constraints-associated-to-a-table-tp17456725p17456725.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message