db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Takashi Saruhashi" <TSaruha...@valueprice.eu>
Subject How can I fetch constraint attribute on Column Level from SYS Tables??
Date Thu, 18 Sep 2008 14:34:01 GMT
Hello all,

My name is Takashi. Now, I want to fetch constraint attributes on Column
level from SYS Tables.
Does anyone know how to fetch it??

I checked Derby's reference manual here,
http://db.apache.org/derby/docs/10.3/ref/rrefsistabs38369.html

Actually, in SYSCOLUMNS Table, there's no association with
SYSCONSTRAINTS Table and vice versa...

However, when I create Table, I can assign some constraints on Column
level indeed.
Therefore, I guess there should be some way to fetch it on Column
level...

Any suggestion is quite appreciated.


Best regards.
Takashi

Mime
View raw message