finding CHECK constraint with DatabaseMetaData

Thread view:

dom - 26 Sep 2005 17:20 GMT

How to find with DatabaseMetaData the check constraints on a table ?

ALTER TABLE T_DISTAN ADD CONSTRAINT CHECK_DISTAN_PDL1_PDL2
CHECK (NO_PDL1 != NO_PDL2);

I can find FOREIGN KEY, UNIQUE AND PRIMARY KEY

Reply to this Message

Lee Fesperman - 26 Sep 2005 21:22 GMT

> How to find with DatabaseMetaData the check constraints on a table ?
>
> ALTER TABLE T_DISTAN ADD CONSTRAINT CHECK_DISTAN_PDL1_PDL2
> CHECK (NO_PDL1 != NO_PDL2);
>
> I can find FOREIGN KEY, UNIQUE AND PRIMARY KEY

Sorry, DatabaseMetaData doesn't support retrieval of CHECK constraints. You'll need to
use capabilities native to your DBMS for retrieving this information from the catalog.

Signature

Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...